RE: DELETE query help please?

[Chris Boget]

> I want to delete from the 'Item' table 
> all the items identified by the folowing query:

If you have MySQL 5+, you can do it using a sub-query:

DELETE FROM 
  Item 
WHERE 
  ProductID IN (
SELECT 
    Item.ProductID
FROM 
    Item, ItemTag
WHERE 
    ItemTag.TagID = '168' 
AND 
    ItemTag.ItemID = Item.ProductID
);

thnx,
Chris


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]