How to find/display unmatched records 1

[tmssales]

Hi folks,

I have 2 tables, contact1 and contact2. Each table has an accountno field. I have 55000 records in contact and 69000 records in contact2. There are 14000 records in contact2 that do not have an associated accountno in contact1. I need to be able to display these 14000 records. Can some one help me with a query here?

I have tried several select versions using left and inner joins to no avail.

Thanks for any help.

 

[swampBoogie]

select * from contact2
where accountno not in (
select accountno from contact1)

 

[tmssales]

thanks, that worked