> 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: sfaroult_at_oriole.com
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: ListGuru_at_fatcity.com (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).
Received on Mon May 13 2002 - 01:43:18 CDT
