hi,

thank you very much .it works
>Please read again carefully my select. I think I updated it while you were replying. The version at the bottom of the message should be now correct, I move it here for your convenience:
>
>

>SELECT Mstr.nam, Mstr.bank, Mstr.sheqno, Mstr.dat, Mstr.tra, S1.Bill_Total FROM Mstr ;
> inner join (SELECT nam, bank, sheqno, dat, SUM(amount) AS bill_total FROM Mstr ;
>group by 1,2,3,4 where dat = m.ldStartDate) S1 ;
>on Mstr.Nam = S1.Nam and Mstr.Bank = S1.Bank and Mstr.SheqNo = S1.SheqNo ;
> and Mstr.dat = S1.dat ;
> ORDER BY Mstr.sheqno INTO CURSOR qTmp
>

>
>
>>hi,
>>same error.
>>

>> SELECT Mstr.nam, Mstr.bank, Mstr.sheqno, Mstr.dat,Mstr.amount  FROM Mstr ;
>> inner join (SELECT nam, bank, sheqno, dat, SUM(amount) AS bill_total FROM Mstr ;
>> on Mstr.Nam = S1.Nam and Mstr.Bank = S1.Bank and Mstr.SheqNo = S1.SheqNo ;
>> and Mstr.dat = S1.dat ;
>> ORDER BY Mstr.sheqno INTO CURSOR qTmp
>>
>>

>>
>>>>hi,
>>>>thank you for reply,
>>>>i try it but error message syntax error
>>>>

>>>>SELECT Mstr.nam, Mstr.bank, Mstr.sheqno, Mstr.dat, Mstr.tra, S1.amount FROM Mstr ;
>>>> inner join (SELECT nam,amount,bank,sheqno,dat,tra, SUM(amount) AS bill_total FROM Mstr ;
>>>> on Mstr.Nam = S1.Nam and Mstr.Bank = S1.Bank and Mstr.SheqNo = S1.SheqNo ;
>>>> and Mstr.dat = S1.dat ;
>>>> ORDER BY Mstr.sheqno INTO CURSOR qTmp
>>>>

>>>>thanks
>>>>>See changes inside.
>>>>>
>>>
>>>Don't include TRA into inner select. That was the idea of the new select, did I make this mistake myself?
>>>
>>>E.g. it should be
>>>

>>>SELECT Mstr.nam, Mstr.bank, Mstr.sheqno, Mstr.dat, Mstr.tra, S1.Bill_Total FROM Mstr ;
>>> inner join (SELECT nam, bank, sheqno, dat, SUM(amount) AS bill_total FROM Mstr ;
>>>group by 1,2,3,4 where dat = m.ldStartDate) S1 ;
>>> on Mstr.Nam = S1.Nam and Mstr.Bank = S1.Bank and Mstr.SheqNo = S1.SheqNo ;
>>> and Mstr.dat = S1.dat ;
>>> ORDER BY Mstr.sheqno INTO CURSOR qTmp
>>>

>>>
>>>Yes, I see I made a mistake myself when copied your select. Hopefully the new one is better and now correct.