Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 MS Access
 How to DELETE within INNER JOIN?

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-03-13 : 08:50:24
marina writes "I use Access2000 and Windows98.
I have 2 tables:orders, itemsOrdered.
I need to delete records from itemsOrdered if field status in table orders has value OPEN.
2 tables have keyfields OrderID.
Please help!
Thanks."

Nazim
A custom title

1408 Posts

Posted - 2002-03-13 : 09:23:36
delete from itemsOrdered
where item in (select item from orders
where status='OPEN')

HTH

--------------------------------------------------------------
Go to Top of Page
   

- Advertisement -