Help with simple SQL Server query
- by Bram
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.
