別のテーブルの値やSELECTした結果でUPDATE

UPDATE tbl1
SET col1 = tbl2.col2
FROM tbl2
WHERE tbl1.id = tbl2.id

UPDATE tbl1
SET col1 = tbl2.col2
FROM (SELECT * FROM tbl2) AS s
WHERE tbl1.id = s.id