On Thu, May 26, 2011 at 1:40 PM, Rick Genter wrote:
>
> The UPDATE statement when multiple tables are involved always drives me nuts.
> I think what you need to do is remove all of the "old." from the SET clause
> and use "triple." in the WHERE clause instead of "old." - and remove the old
> tab
Andy Chambers wrote:
> I'm confused about the correct syntax for updating an aliased table. I want
> to update triple from triple_updates
> where the data is different and tried to use the following
>
> update triple old
>set
> old.obl
The UPDATE statement when multiple tables are involved always drives me
nuts.
I think what you need to do is remove all of the "old." from the SET clause
and use "triple." in the WHERE clause instead of "old." - and remove the old
table alias from the UPDATE.
On Thu, May 26, 2011 at 9:38 AM, Andy
I'm confused about the correct syntax for updating an aliased table. I want
to update triple from triple_updates
where the data is different and tried to use the following
update triple old
set
old.obln = new.obln, old.ointv = new.oint