UPDATE tbl_prescription_report_item as pri Left JOIN tbl_prescription as p ON p.id = pri.pid Left JOIN tbl_company as c ON p.compid = c.id SET pri.dispensingfees = c.dispensingfees, pri.specialpackagingfees = c.specialpackagingfees where 1;UPDATE t1 SET t1.column = t2.column FROM Table1 t1 INNER JOIN Table2 t2 ON t1.id = t2.id;UPDATE accounts SET (contact_first_name, contact_last_name) = (SELECT first_name, last_name FROM salesmen WHERE salesmen.id = accounts.sales_id);