Re: SQL Help Urgent!!!!!!!!!

I got it.Thank you Gurus for your reply.

Regards
syed

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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: sultan
  INET: ssyed_at_fine.co.ae

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