Status: Resolved (View Workflow)
Affects Version/s: None
From the forum post, two tables that relate to each other:
EmployeeMasterEntity (PK EmployeeID, FK Departments)
OrganizationalUnitEntity (PK OrganizationalUnitID, FK Managers)
With data like:
Will not return the correct results for a query such as:
This is due to using the wrong relationship for the navigation.