Overwrite your table by taking left join with another table. Let me know if
you want any syntactical help.
On 14-Feb-2018 12:54 PM, "Andy Srine" wrote:
> Hi Team,
>
> Whats the best way to do an update on one table from another? Variations
> of this syntax below doesn't seem to work:
>
> UPDATE
Hi Team,
Whats the best way to do an update on one table from another? Variations of
this syntax below doesn't seem to work:
UPDATE table_x
SET column_1 = B.column_1
FROM
table_y B
WHERE column_2 = B.column_2
;
Thanks,
Andy