I have two tables EMPLOYEE and WORKING, I want to do a select on the table EMPLOYEE that returns all EMPLOYEES not working.

I use the following SQLPLUS Select statment.

select emp.name
from EMPLOYEE emp,WORKING wk
where wk.employeeID!= emp.employeeID;

Lets say TOM SMITH is working, but Susan Thomas and Steve Jones is not.

what this command returns is

Susan Thomas
Steve Jones
Tom Smith
Susan Thomas
Steve Jones


If I run the select satement
select emp.name
from EMPLOYEE emp,WORKING wk
where wk.employeeID = emp.employeeID;

It only returns

Tom Smith

There is a problem with the !=.

Thanks for any help

Tony

Select ta.*
from tableA ta
LEFT OUTER JOIN
tableB tb ON
ta.id = tb.id
where tb.id IS NULL;

Alternatively,

Select ta.*
from tableA
where id NOT IN
(select id
from tableB);

Thanks they both worked.

Cheers Tony