Here
SELECT n_505_f5,n_509_f9,
plan_id,tp_order,n_503_f3,;
you need to provide an alias. In fact, it's a good idea to always provide an alias for every field if multiple tables are involved.
>Hi Gang!
>
>The code below gives me an error....
>
>" 'Plan_ID' is not unique and must be qualified"
>
>
>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 ;
> 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
>
>
>In rx_claim, Plan_ID refers to the Plan_ID in the Third_party_plans... the Plan_ID is unique in third_party_plans...
>
>So, what should I look for? First time I've run across this error!!!!
>
>Thanks!
If it's not broken, fix it until it is.
My Blog