SQL Delete Help

[markphsd]

What's wrong with this:

DELETE
From ContactPurchases
INNER JOIN OrderDetails
ON ContactPurchases.OrderDetailID=OrderDetails.OrderDetailID

I get this error:

Server: Msg 156, Level 15, State 1, Line 3
Incorrect syntax near the keyword 'INNER'.

But it works find when using it as a SELECT.

thanks,

Mark P.

http://www.cafecartel.com

Providing Low Cost Powerful Point of Sale Solutions.

 

[gmmastros]

You can only delete from one table at a time. As such, you need to specify which table to delete from. You do that like this...

DELETE [!]ContactPurchases[/!]
From ContactPurchases
INNER JOIN OrderDetails
ON ContactPurchases.OrderDetailID=OrderDetails.OrderDetailID

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[markphsd]

Fastest help for me ever.

Thank you.

Mark P.

http://www.cafecartel.com

Providing Low Cost Powerful Point of Sale Solutions.