sorry if this is painfully obvious but I can't seem to
figure it out...It seems to me (unless I am reading it
waay wrong) that the mysql DELETE command does NOT
allow you to refer to columns from other tables! 

I have identified certain records to be deleted from 3
tables and created a temp table to hold the item_id's
to look up and delete...BUT HOW?! Ideally it would be:

DELETE FROM prod, prod_price, prod_cat 
WHERE temp.prod_id = prod.prod_id 
AND temp.prod_id = prod_price.prod_id 
AND temp.prod_id = prod_cat.prod_id 



Make it idiot-proof and someone will make a better idiot.

Do You Yahoo!?
Great stuff seeking new owners in Yahoo! Auctions!

PHP Database Mailing List (
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to