Select * from Table where record doesn't exist in other table
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?
FROM TableA a
On a.keyField = b.keyField
WHERE b.keyField is NULL
Thank you, that was it exact. LEFT JOIN
very welcome. happy to help
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)