>No Sir, it didn;t worked.
>
>
>
>
>>>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
>>
>>Try
>>
>>

>>LEFT JOIN MASTER MSTR on AMT.Filename==MSTR.accountno
>>

>>
>>in the join (changed = with ==), assuming that both fields have the same length

Have you checked MASTER table for duplicate accountno values?