>>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 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
>
>Have you checked MASTER table for duplicate accountno values?
Yes there are Duplicate entries in Master Table, I will correct it up now. Thanks.
Harsh