update from select

update from select

UPDATE TABLE1
   SET COL1 = B.COL1
  FROM TABLE2 B
 WHERE TABLE1.KEY = B.KEY