I have to update a field with a value which is returned by a join of 3 tables.
,im.sku as iSku
,gm.SKU as GSKU
,mm.ManufacturerId as ManuId
item_master im, group_master gm, Manufacturer_Master mm
im.mf_item_number like 'STA%'
and gm.ManufacturerID = mm.ManufacturerID
I want to update the
mf_item_number field values of table
item_master with some other value which is joined in the above condition.
How can I do this in MS SQL Server?