Help with simple SQL Server query
Posted
by Bram
on Stack Overflow
See other posts from Stack Overflow
or by Bram
Published on 2010-05-29T22:50:32Z
Indexed on
2010/05/29
22:52 UTC
Read the original article
Hit count: 370
I have to tables as follows;
- Employees: Name nvarchar(50), Job Title nvarchar(50) and Salary int.
- Employers: Name nvarchar(50), Job Title nvarchar(50)
I would like to select every item from the 'Employers' table where 'Job Title' does NOT show up in the 'Employees' table.
I know this is a simple query but it has me stumped. I'd be grateful for any help. Thanks.
© Stack Overflow or respective owner