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?