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]

Reply via email to