With a many-to-many relationship where there are employees and addresses with a join table "AddressEmployee"


<class name="Employee" table="Employee">
......
<bag name="Addresses" table="AddressEmployees">
<key column="EmployeeId" />
<many-to-many class="Address" column="AddressId"/>
</bag>
</class>

What is the best way (best practice) to do a query returning Employees with an Address.City = "Sydney".

TIA

I'd do it something like this:



Cheers,

Symon.

Oops! :oops:

What I meant was:



If you use a left join you'll get all employees anyway! The above query should only return employees who have addresses that are in Sydney.

Cheers,

Symon.