What would be the proper syntax for a select statement which excludes rows based on a compound key? For example:
SELECT * FROM Table1
Where ID1 and ID2 not in Table2
This is obviously the wrong syntax, but I would like all of the items is Table1 where the key of ID1 and ID2 do not exist in Table2.
Thank You
Rollin Burr
Politicians and diapers have one thing in common. They should both be changed regularly, and for the same reason.