Select * from Table where record doesn't exist in other table

[mparker1113]

Hi,

I have two tables, each with a similar field.

The first table has priority, so I take all the values from there and put them into a temp table. (select * from table1 where criteria).

Then, I want to get the critera for table2, but not where the samefield value is already in my temptable (select * from table2 if sameField is not in tempTable)

I have tried many solutions, but this is eluding me.

Is this possible to do?

[russell]

SELECT fieldList
FROM TableA a
LEFT JOIN
TableB b
On a.keyField = b.keyField
WHERE b.keyField is NULL

[mparker1113]

Thank you, that was it exact. LEFT JOIN

[russell]

very welcome. happy to help :)