Querry

  • Thread starter Thread starter inemuu
  • Start date Start date
I

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?
 
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
 
Back
Top