DELETE query help please?

[Mark Kelly]

Hi

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

SELECT 
    Item.ProductID 
FROM 
    Item, ItemTag 
WHERE 
    ItemTag.TagID = '168' 
AND 
    ItemTag.ItemID = Item.ProductID;

but I'm not sure how to go about it. Can anyone help?

Thanks

Mark


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