A value that is returned from a join of three tables must be updated in a field.
,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 replace a value that is joined in the aforementioned condition with the value from the mf_item_number column of the item_master database.
How can I do this in MS SQL Server?