UPDATE coSuper2 SET PrefGroupID = 90 FROM coSuper2 s2 inner join coInv i on i.InvID = s2.InvID WHERE i.PrimeDesc LIKE '%SUTURE%'.
>update coSuper2 set coSuper2.PrefGroupID=90 where >(select coSuper2.invid, coinv.PrimeDesc,coSuper2.PrefGroupID >from coSuper2 inner join >coInv on coSuper2.InvID=coInv.InvID >where coinv.primedesc like '%SUTURE%') >