I have an Employee Entity with ManyToOne relationship with Location Entity. Here is how they are related.

In Empooyee entity:
--------EmployeeId
--------ResidenceLocation(ManyToOne -> Location)
--------OfficeLocation(ManyToOne -> Location).

In Location entity:
--------LocationId
--------ResidenceEmployee(List) (OneToMany -> Employee)
--------OfficeEmployee(List) (OneToMany -> Employee)

I want to get a list of employees who belong to a particular Location. The problem is that an Employee may have his Residence Location and Office Location same. Thus he will appear in both. How do I count him only once when I want to find total Number of Employees for a particular Location.

regards,
Nirvan.