Querry

[inemuu]

I have an employee table that has a relationship w/ a dependent table
and also a deptment table that has a relationship with employee table.
How do I perform a query to pull at managers from Dept table who do not
have a dependent?

 

[Amy Blankenship]

Without having access to your table structure, something like

SELECT EmployeeID FROM dept WHERE IsManager = -1 AND EmployeeID NOT IN
(Select EmployeeID FROM dependent)

HTH;

Amy