>>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?

Yes there are Duplicate entries in Master Table, I will correct it up now. Thanks.