You cannot refer to other tables. Which row in temp would MYSQL know to refer to test the WHERE clause? That is, if temp has multiple rows, which row in temp would MYSQL check against to determine prod_id?
-----Original Message----- From: Adv. Systems Design [mailto:[EMAIL PROTECTED]] Sent: Friday, February 01, 2002 2:43 PM To: PHP List Subject: [PHP-DB] DELETE in mysql? 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 TIA Luis ===== ---------------------------------------------------- Make it idiot-proof and someone will make a better idiot. __________________________________________________ Do You Yahoo!? Great stuff seeking new owners in Yahoo! Auctions! http://auctions.yahoo.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]