Re: Joining the one column with two other columns

gspk_at_yahoo.com (Prince Kumar) wrote in message news:<629275ba.0308211417.3c7fc1ea_at_posting.google.com>...
> Hi:
>
> I have the following two tables.
>
> SQL> desc t
>
> Name Type
> -----------------------------------------
> ----------------------------
> RECORD# NUMBER PK_T (RECORD#)
>
> SQL> desc pp
>
> Name Type
> -----------------------------------------
> ----------------------------
> PKEY NUMBER(8) FK references T
> (record#)
> RKEY NUMBER(8) FK references T
> (record#)
> AMOUNT NUMBER
>
> FK
>
> I have the two sqls.
> ===================
> select sum(pp.amount) as ptot from pp, t where pp.pkey = t.record#
>
> select sum(pp.amount) as rtot from pp, t where pp.rkey = t.record#
>
>
> I am wondering whether "ptot" and "rtot" can be abtained in the same
> select statement (ie, in the above I have two SQLs to get the result,
> can I get the same using just ONE SELECT statement?)
>
> something like
> "select sum(pp.amount) ptot, sum(pp1.tot) rtot from pp, pp pp1 ..."
>
> Thanks,

Why post this question? Why not just run the query and see?

HTH -- Mark D Powell -- Received on Thu Aug 21 2003 - 20:56:35 CDT