Try this.
update coSuper2 set coSuper2.PrefGroupID=90 from coSuper2 inner join
coInv on coSuper2.InvID=coInv.InvID
where coinv.primedesc like '%SUTURE%'
>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%')
>