>I am using the following SQL . The fisrt SQL select the proper Number of Records but the later sql increase my record size. I just want to Get/Update Exchange column infront of the Account Number as Generated by 1st SQL.
>
>
>
>SELECT FIlename,InvoiceNo,PhoneNo,N_Month,Amtpayable FROM Amountpayable INTO CURSOR AMTPAYABLE
>
>Select AMT.*,MSTR.exchange From AMTPAYABLE AMT LEFT JOIN MASTER MSTR on AMT.Filename=MSTR.accountno INTO CURSOR MONTHEXG READWRITE
>
>
>
>What would be the right code ?
>
>Regards
Try
LEFT JOIN MASTER MSTR on AMT.Filename==MSTR.accountno
in the join (changed = with ==), assuming that both fields have the same length
"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