LEFT JOIN in UPDATE
| From: | Adv. Systems Design | Date: | Sun, 03 Feb 2002 19:55:14 +0000 |
| Subject: | LEFT JOIN in UPDATE | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-16462@lists.php.net to get a copy of this message | ||
hi...trying to circumvent the limitation of the DELETE
statement only being able to use its own table...idea
is to mark the records to be deleted via an UPDATE
statement which allegedly accepts LEFT JOIN and then
performing the DELETE statement.
Question is how to properly form a LEFT JOIN using
UPDATE... I tried:
UPDATE product_price LEFT JOIN temp
SET product_price.product_price_vdate = 1 (del flag)
ON product_price.product_id = temp.product_id
WHERE temp.product_id IS NOT NULL
as well as some other combos...to no avail! Anyone
used this know the right syntax much appreciated!!!
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