>I run the following lines of code in VFP command window and get the error. I swear that the fieldname (custmer_id in this case) is qualified, but it still won't run. Any one see something I missed?
>
>
>select ctemp.custmer_id, state, potncust.name_full from ctemp, potncust ;
> where ctemp.custmer_id = potncust.custmer_id order by state, custmer_id into cursor ctemp1
>
>select potncust.custmer_id, state, potncust.name_full from ctemp, potncust ;
> where ctemp.custmer_id = potncust.custmer_id order by state, custmer_id into cursor ctemp1
>
>
>TIA
>Beth
In ORDER BY customer_id is not qualified and state also.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.