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 innerjoin
coInv on coSuper2.InvID=coInv.InvID
where coinv.primedesc like'%SUTURE%')