Hi
I need to build a query where I have 2 tables
MANAGERS
DPT_ID | MANAGER
1 | PERSON_ID1
2 | PERSON_ID2
and SALESMEN
DPT_ID | PERSONID
1 | PERSON_ID1
1 | PERSON_ID7
1 | PERSON_ID8
2 | PERSON_ID4
2 | PERSON_ID5
2 | PERSON_ID6
and 2 queries to retrieve departments where the manager is and isnīt a salesman in the department.
For the above data, the first query would return DPT_ID = 1 and for the second DPT_ID = 2
Thanks