Galsaba,
It's an outer join. So,
SELECT EMPLOYEE_TBL.ID AS EMP_ID, EMPLOYEE_TBL.SEARCH_NAME AS EMP_NAME FROM
EMPLOYEE_TBL_OLD AS EMPLOYEE_TBL LEFT OUTER JOIN EMPLOYEE_TBL_NEW ON
EMPLOYEE_TBL.ID = EMPLOYEE_TBL_NEW.EMPLOYEE_ID
WHERE EMPLOYEE_TBL.ID IS NULL;
The key to it is to return all records in the left (or right) table and only
those records in the other table that match and then look for nulls on the
joined column.
"Galsaba" <ga*****@aol.com> wrote in message
news:20***************************@mb-m19.aol.com...
I have two list of emloyees. They are linked by emloyeeID.
How can I make a query that will have all the employees that appears in
table A, but not in table B.
I asked this question in the past, and I was told that there is a wizard
for it, but I could not find it. So may be I can get the SQL script for it.
Thanks,
galsaba