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