[RESOLVED] show records that do not match

[webchick2]

Table1: account, description, reason
Table2: account, name, address, city, state, zip

I want to be able to show all accounts from Table1 that are not listed in Table2. Can someone please help me figure out how to best achieve this? Thanks in advance 🙂

[devinemke]

SELECT * FROM table1 WHERE account NOT IN(SELECT account FROM table2)

[webchick2]

Thank you!!! That worked perfectly!