selecting value from table1 where it does not exist in table2 2

[RichS]

How do I select a value from one table where it doesn't exist in another table? Thanks for any help.

Rich

 

[foxdev]

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

Robert Bradley

http://www.foxdev.com/

 

[RichS]

perfect. Thank you.