>>You need to use JOIN condition, e.g.
>>
>>

>>UPDATE cur SET CarrID = G.Carr, Benefit = G.CovDesc8 ;
>>		FROM GrpsPlansCarrs G INNER JOIN (lcCursor) cur ;
>>                                       ON cur.GrpID + cur.PlanKey = g.Full_Key
>>

>
>I am quite sure I do not need a join, but I might be wrong.

You do need it according to the original logic. (he was doing seek and replace).