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

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

Since you only have two seperate queries the following will work.

Select ptot, rtot
from (select sum(pp.amount) as ptot from pp, t where pp.pkey = t.record#) A,

     (select sum(pp.amount) as rtot from pp, t where pp.rkey = t.record#) B

Dave Received on Fri Aug 22 2003 - 13:12:19 CDT