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%'
          )