UPDATE tbl_mg_materials m
SET m.spe_code = b.bar_barcode
FROM b.tbl_mg_barcode
JOIN tbl_mg_materials m ON m.material_id = b.material_id
UPDATE tbl_mg_materials m
SET m.spe_code = b.bar_barcode
FROM b.tbl_mg_barcode
JOIN tbl_mg_materials m ON m.material_id = b.material_id
test
New contributor
Geldi Akmurat is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.