I'm hoping someone can help structure this command to it actually works, below is what I was thinking,but it causes a sytax error.

Thanks for anyhelp

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