I've been stuck on this SQL query for a while.

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.

Something like:



Except adapted for a two columns search:



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!)?

Thanks

B.

Have you tried using the Unmatched Query Wizard?

No. Where can I find that?

Queries Tab: New


Edited by: niesz on Thu Jul 27 10:23:52 EDT 2006.

This will only work for one field. The wizard wont let me chose more.

Any other ideas?

You could try something like:

SELECT Table1.ID, Table1.MyField1, Table1.MyField2
FROM Table1 LEFT JOIN Table2 ON (Table1.MyField2 = Table2.MyField2) AND (Table1.MyField1 = Table2.MyField1)
WHERE (((Table2.MyField1) Is Null) AND ((Table2.MyField2) Is Null));

This example uses 2 fields in common.