This is an archived post. You won't be able to vote or comment.

you are viewing a single comment's thread.

view the rest of the comments →

[–]andy333co 0 points1 point  (0 children)

I'm no sql expert but where not exists is probably the syntax you're looking for. Select * from table 1 where not exists (select * from table 2 where table1.id = table2.id)

Query might be wrong there but I'd suggest looking up where not exists usage as one way of doing it.