In your case LEFT OUTER JOIN is the way to go (and the fastest)

but with a lot of columns (and a smallish database) EXCEPT can be powerful consider this application

table 1 is a download of a cash register (no more than 4000-1000 items)

table 2 is a SQL table supposedly in complete synchronization with said cash register table

EXCEPT will efficiently "pop" the discrepancies