I have two copies of the same table. One is before some rows have been deleted the other is after. That would be simple enough but I have multiple key fields. I would like to have a command that would find the lines that are missing in the new copy.
select ID from TABLE_COPY2 where ID not in (select ID from TABLE_COPY1)
Except adapted for a two columns search:
select ID, ID2 from TABLE_COPY2 where (ID, ID2) not in (select ID, ID2 fril TABLE_COPY2)
This syntax does not work but it's that logic I would like to use.
Any ideas on how I could do this (with or without my preferred logic!)?