SQL Statement - UPDATE

Update data with new value
UPDATE tablename SET fieldname1 = values, fieldname2 = values WHERE condition

Update data with value in another table
UPDATE tablename1 SET tablename1.fieldname=tablename2.fieldname FROM tablename2 WHERE condition