Trying to Select info from table that is not found in another table

[VBSQL]

I have two tables that are linked with the same ID number's
One holds Orderinfo and the other Iteminfo, I need to SELECT the ID's that are in the table with the Orderinfo where the ID does not exist in the Iteminfo table and then remove it from the Orderinfo table. All of this is being done with in a VB Program using recordsets. Do You Have any Ideals to help!

Thanks.

 

[tlbroadbent]

You can do what you want with two SQL statements.

First statement to select records for archiving, documentation, etc.

Select OrderInfo.*
Where ID Not In (Select ID From Iteminfo)

Second statement deltes non matching records.
Delete OrderInfo
Where ID Not In (Select ID From Iteminfo)
Terry

http://members.home.net/tlbroadbent/prog.htm

The reason why worry kills more people than work is that more people worry than work. - Robert Frost