UPDATE coSuper2 SET coSuper2.PrefGroupID = 90 WHERE coSuper2.invid IN ( SELECT coSuper2.invid FROM coSuper2 INNER JOIN coInv ON coSuper2.InvID=coInv.InvID WHERE coInv.primedesc like '%SUTURE%' )