//mssql server
 
update        Table1
set        Table1.col3 = Table2.col3
from        Table1
join       Table2 on Table1.col1 = Table2.col2
where        Table1.col3 <> Table2.col3
 
 
// mysql server
 
UPDATE restarih p
INNER JOIN rezer pp
ON p.id = pp.rid
SET p.ytsay =p.ytsay +pp.ykisi;
WHERE p.dateCreated ='2004-01-01'
 
UPDATE product p
LEFT JOIN productPrice pp
ON p.productId = pp.productId
SET p.deleted = 1
WHERE pp.productId IS null