Delete query question

[MacrosTheBlack]

If I have 2 tables (eg called Product + orders) and I want to delete all orders which do not have a product within the product table how could i do it assuming both tables have a "ProdID" field.

 

[r937]

delete 
  from orders
 where ProdID not in
      (select ProdID from products)

i'm not even going to ask how it is that you managed to create orders for products that don't exist



rudy | r937.com | Ask the Expert | Premium SQL Articles
SQL for Database-Driven Web Sites (next course starts March 6 2005)

 

[MacrosTheBlack]

Thanks for that

The 2 tables I have to work with are completely different, prod and orders seemed easier as an example.