sql statement

[Thai]

Hello again.

If Table1 and Table2 both have the field called NUMBER, what sql statement would I use to return all fields from Table1, where NUMBER from Table1 DOES NOT exist in NUMBER from Table2? I've been trying a few things but none work, please help if you can.

Thai

[JHausmann]

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

[Thai]

Thanks for the help, it works now :)

Thai