>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.
"The five senses obstruct or deform the apprehension of reality."
Jorge L. Borges?
"Premature optimization is the root of all evil in programming."
Donald Knuth, repeating C. A. R. Hoare
"To die for a religion is easier than to live it absolutely"
Jorge L. Borges