>>

SELECT n_505_f5,n_509_f9,rx_claim.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 ;
>>	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
>>

>
>I must have lost my eyesight during the operation!!!!
>
>Egads!!! I have looked at this SELECT for about 4 HOURS and did not see the PLAN_ID in the first line!!!!
>
>Thanks!

You're welcome. The trick is to prefix all fields which exist in more than one table, with the name of the table and a period.