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.
| 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-------------------------------------------------------------- |
 |
|
|
|
|
|
How to DELETE within INNER JOIN?