sql to see all diff between two table

I have duplicated table, table1 and table2. Then table2 has been updated with some fields.
How to get the all diff between two tables using sql?

following does not work for me:

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

thank you for your help!

ydeng Received on Sat Sep 23 2000 - 09:35:21 CDT