Delete multiple items
Posted on 2012-09-18
I am Very, very new to SQL and need a bit of help. I need to create a delete statement that
can handle multiple items in the wholesaleID. Here is the statement that I use
when I am deleting 1 condition at a time. Very time consuming.
WHERE WholesaleID = '99-MW' AND [Data Date] = '2012-09-11'
I would like to also delete 12-MW, 14-MA, 22-SW, 30-MA, 88-SW which are wholesaleID's.
Is there a way to incorporate these items into the single item statement so that I am not having to go back change it one at a time?