Jump to content

[SOLVED] complex query


fuelbox

Recommended Posts

Hi all. I'm no SQL guru and I'm hoping someone can help me build a query.

I need to delete 1 or multiple rows from 2 different tables. I believe this (below) will work just fine if I'm only deleting 1 row at a time from each table.

 

DELETE ecart.orderdetails, ecart.orders FROM ecart.orderdetails, ecart.orders WHERE orderdetails.DetailOrderID = 9 AND orders.OrderID = 9;

 

However, there will be times that I'll need to delete more than 1 row.... kind of like this.....

 

DELETE ecart.orderdetails, ecart.orders FROM ecart.orderdetails, ecart.orders WHERE orderdetails.DetailOrderID = 9,10,11 AND orders.OrderID = 9,10,11;

 

although, this doesn't work, but at least you can see what I'm trying to accomplish.

If anyone has any ideas, I'd love to hear them.

 

Thanks.

 

Steve

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.