xxxxxxxxxx
UPDATE t1
SET t1.column = t2.column
FROM Table1 t1
INNER JOIN Table2 t2 ON t1.id = t2.id;
xxxxxxxxxx
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;