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 2709 Records

Select AMT.*,MSTR.exchange From AMTPAYABLE AMT LEFT JOIN MASTER MSTR on AMT.Filename=MSTR.accountno INTO CURSOR  MONTHEXG READWRITE && selects 3102 Recodrs

What would be the right code ?

Regards