Question

  Asked: Apr 18 2008   5:53 PM GMT
  Asked by: Samotek

Delete query

Can you help me solve the following problem. Whenever i have an order where the field Audit = True, i will have to delete all the previous orders having the Audit = True. And only when customerid = 121. With other words i have to delete the previous orders having Audit = true but not the last one.
My query is the following :
SELECT [orders].[orderid], [orders]. FROM orders INNER JOIN Customers ON [orders].[customerid]=[Customers].[Customerid]
WHERE ((([orders].
I have to build a delete query deleting all the previous orders where Audit = True and Customerid = 121.
I need help

 RATE THIS ANSWER
-1
Click to Vote:

•   0
•  -1

delete from Orders
 where CustomerId = 121 and OrderID <> (select max(OrderId) from Orders where CustomerID = 121)