<t><br/>
UPDATE im<br/>
SET mf_item_number = gm.SKU --etc<br/>
FROM item_master im<br/>
JOIN group_master gm<br/>
ON im.sku = gm.sku <br/>
JOIN Manufacturer_Master mm<br/>
ON gm.ManufacturerID = mm.ManufacturerID<br/>
WHERE im.mf_item_number like 'STA%' AND<br/>
gm.manufacturerID = 34<br/>
<br/><br/><br/>
To make it clear... The UPDATE clause can refer to an table alias specified in the FROM clause. So im in this case is valid<br/>
<br/>
Generic example<br/>
<br/>
<br/>
UPDATE A<br/>
SET foo = B.bar<br/>
FROM TableA A<br/>
JOIN TableB B<br/>
ON A.col1 = B.colx<br/>
WHERE ...<br/>
<br/></t>
