[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 NO
on 2/3/02 3:36 PM, Lutz Brückner at [EMAIL PROTECTED] appended the following
bits to my mbox:
>> 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_
I was simply going by the docs themselves:
http://www.mysql.com/doc/A/N/ANSI_diff_Sub-selects.html
(see bottom of page)
...and to say that its up to the programmer to provide
such features is like saying that the lack of brakes
in my Yugo was a feature "designed" that way because
it is up to me t
[EMAIL PROTECTED] (Adv. Systems Design) writes:
> I was simply going by the docs themselves:
> http://www.mysql.com/doc/A/N/ANSI_diff_Sub-selects.html
> (see bottom of page)
yes, using REPLACE may be a solution. But you have to make a copy of
the original table, because REPLACE cannot access th