> sultan wrote: > > Hi gurus > > I have two tables like this > > > SQL> select * from bb; > > ID AMOUNT DT > ---------- ---------- ------------------------------ > 1 1000 10-MAY-02 > > > > > SQL> select * from cc; > > ID AMOUNT > ---------- ------------------- > 1 200 > 1 300 > 1 500 > > > My query like this > ============= > SQL> select a.id,sum(a.amount),sum(b.amount) from bb a,cc b where > 2 a.id=b.id > 3 group by > 4 a.id; > > ID SUM(A.AMOUNT) SUM(B.AMOUNT) > ---------- ------------- > ---------------------------------------- > 1 3000 1000 > > > **** Based on the details table rows it sum up three times the master > amount ,that is why it shows 3000. > > > But my output should be like this > ======================== > > ID SUM(A.AMOUNT) SUM(B.AMOUNT) > ---------- ------------- > ---------------------------------------- > 1 1000 1000 > > > Anybody can help me in this issue please. > > Regards. > syed
Do the GROUP BY in an in-line view. BTW in the case you give as example, you just need to put B.AMOUNT in the GROUP BY clause. -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
