Can someone help me woth an SQL command to remove Items that were imported on accident? I need to remove the items with the following information:
Inactive=yes Price=$0.00 Date created=8/24/2009
Any help would be appreciated Thank-you Adam
SQL Command Help for HQ
Aug 25, 2009
1 Replies
you need to remove the entries from the supporting tables before removing the item itself:
delete supplierlist from item join supplierlist on itemid=item.id where inactive=1 and price=0 and datecreated>'8/24/09' and datecreated'8/24/09' and datecreated'8/24/09' and datecreated'8/24/09' and datecreated Can someone help me woth an SQL command to remove Items that were imported on
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required