Re: LEFT JOIN in UPDATE
| From: | (Lutz Brückner) | Date: | Sun, 03 Feb 2002 20:36:54 +0000 |
| Subject: | Re: LEFT JOIN in UPDATE | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-16463@lists.php.net to get a copy of this message | ||
asd_2000@yahoo.com (Adv. Systems Design) writes:
> 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
I just read http://www.mysql.com/doc/U/P/UPDATE.html once
more,
but can not find anything about mysql supporting JOIN in UPDATE
statements.
Sorry,
Lutz