sql - UPDATE using select statement and inner join - Stack Overflow

UPDATE using select statement and inner join up vote 1 down vote favorite UPDATE TABLE1 set TABLE1.col1 = TABLE2.col1 FROM TABLE2 INNER JOIN TABLE3 ON COL2 = TABLE2.COL2 WHERE TABLE1.COL3 = TABLE3.COL3 Will the above query work ...

stackoverflow.com