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