Err<Br>UPDATE tbltasks_test left join tblstaff on (tblstaff.staffid=tbltasks_test.addedfrom) SET tbltasks_test.rel_id = tblstaff.reportid where tbltasks_test.id=