Hello, everyone

It's about a MSSQL2k database. Some of the tables (used as junction tables) don't have a PK, but a compound pk, on two columns. My problem is now I have to find which records are in one table and aren't in another. This is a good candidate for a subselect

select pk from table1 where pk not in (select pk from table2)

. Well... I have two columns. How to say that? select col1,col2 from table1 where pk1,pk2....somebody stop me, I'm already laughing :0


Seriously, can anyone help me in this issue? (changing the tables is out of question)

Thank you.