delete query

[samotek]

From my query, enumerated below,i want to delete the productId = 2 from orderid = 4.I want to build a delete query in sql view. and later on give the command run sql.How can i do that ?

SELECT orders.orderid, products.Productid FROM products INNER JOIN (orders INNER JOIN [order details] ON orders.orderid = [order details].OrderID) ON products.Productid = [order details].ProductID;

 

[JerryKlmns]

DELETE *
FROM [order details]
WHERE orderid = 4 AND Productid = 2

I guess that the products requested in an order are kept on the order details table!