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: 346

Filed under:
|
|

I have to tables as follows;

  1. Employees: Name nvarchar(50), Job Title nvarchar(50) and Salary int.
  2. 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

Related posts about sql

Related posts about sql-server-2008