sql update from select

1--update query example
2 UPDATE table_name
3 SET column1 = value1, column2 = value2, ...
4 WHERE condition; 

1UPDATE YourTable 
2SET Col1 = OtherTable.Col1, 
3    Col2 = OtherTable.Col2 
4FROM (
5    SELECT ID, Col1, Col2 
6    FROM other_table) AS OtherTable
7WHERE 
8    OtherTable.ID = YourTable.ID

1UPDATE t1
2SET t1.COL1 = t2.COL1, t1.COL2 = t2.COL2
3FROM MY_TABLE AS t1
4JOIN MY_OTHER_TABLE AS t2 ON t1.COLID = t2.ID
5WHERE t1.COL3 = 'OK';

1--the simplest way of doing this 
2UPDATE
3    table_to_update,
4    table_info
5SET
6    table_to_update.col1 = table_info.col1,
7    table_to_update.col2 = table_info.col2
8
9WHERE
10    table_to_update.ID = table_info.ID