Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Transact-SQL (2000)  re: Inkling to use set operators but not working

Author  Topic  msa969 Starting Member 13 Posts Posted - 2001-11-12 : 13:16:02 I have a table called employer employer empID | job | deptno I want to query the table so that it retrieves job titles that do not occur in both departs. i.e Job ---- ANALYST PRESIDENT Here is my reasoning so far: select job from emp where deptno = 10 /*something i.e set operator */ select job from emp where deptno = 20; So far set operators is not working. Perhaps I need to take a different approach?