The following query should work if I understand what you're attempting correctly. Use at your own risk though ;)

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

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

Reply via email to