[EMAIL PROTECTED] (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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
