Re: DELETE query help please?

[Yoge]

This should work
DELETE Item FROM Item,ItemTag WHERE Item.ProductID =ItemTag.ItemID AND 
ItemTag.TagID = '168'

Mark Kelly wrote:
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


  

--
Yoge,
AdventNet, Inc.
925-965-6528
[EMAIL PROTECTED]
site24x7.com


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