updating column data with lookup from another

merge dbo.products tgt
using dbo.vendors src on tgt.vendor_code = src.vendor_code
When matched then
UPDATE 
SET vendor_id = src.id;