[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


PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to