>>>>
>>>>It wants to know which plan_id to use in the select (even though YOU know it is the same value).
>>>
>>>I changed it to this...
>>>
>>>

>>>SELECT n_505_f5,n_509_f9,plan_id,tp_order,n_503_f3,;
>>>	n_558_aw,n_559_ax,n_507_f7,n_506_f6,n_409_d9, ;
>>>	n_504_f4, n_526_fq, rx_claim.plan_id AS myplanid ;
>>>	FROM rx_claim, third_party_plans ;
>>>	WHERE (rx_claim.rx_no = rx.rx_no);
>>>		AND (rx_claim.refill_no = rx.refill_no) AND ((rx_claim.statuscode = 2) OR (rx_claim.statuscode = 4));
>>>		AND (rx_claim.n_103_a3 = "B1") ;
>>>		AND (rx_claim.plan_id = third_party_plans.plan_id) ;
>>>		ORDER BY rx_claim.tp_order DESC INTO CURSOR csrMultiThirdParty
>>>

>>>
>>>same result.............. sigh....
>>
>>Did you try my changed code?
>
>Yes!!! I overlooked the PLAN_ID in the first line.... for about like 3 - 4 Hours!!!!
>
>Sigh!!!
>
>Thanks!

It happens more and more frequently when you pass 40. To me it happens all the time!