UPDATE table1 based on table2 ---

[link9]

Hello all --

I have two tables, we'll call them table1 and table2. The link between the two is a column called 'link', and I need to be able to update table1 based on the value that is in table2 with the same 'link', but can't seem to get the syntax correct.

So here would be a JOIN between the two:

SELECT * FROM table1 INNER JOIN table2 ON table1.link = table2.link

and the column I need to update in table1 is called 'verb' -- also has the same name in table2.

What would be my syntax?

Thanks!
Paul Prewett

 

[link9]

got it:

update table1
set verb = new.verb
from table2 new inner join table1
on new.link = table1.link