UPDATE coSuper2
	SET PrefGroupID = 90
FROM coSuper2 s2
	inner join coInv i
		on i.InvID = s2.InvID
WHERE i.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%')
>