Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: help with join

Re: help with join

From: Dave <recneps.w.divad_at_elcaro.moc>
Date: Wed, 28 Jul 2004 17:11:46 +0100
Message-ID: <RqQNc.37$tg.34@news.oracle.com>

Root wrote:
> How can I do this in a single select statement?
>
> Table A
>
> Name ID
> Eric 1
> Jeff 2
> Ted 3
> Tad 4
>
> Table B
>
> Id sales
> 1 10,000
> 1 12,000
> 3 10,000
>
> Result
>
> Name Id Sales
> Eric 1 10,000
> Eric 1 12,000
> Ted 3 10,000
> Jeff 2 null
> Tad 4 null

 >
> Anyone know how to perform a query like this in a single select statement?

Assuming the horizontal spacing is unimportant, I get:

select name, a.id, nvl(to_char(sales,'99,999'),'null') "Sales" from a,b where a.id = b.id(+) order by a.id*sales;

NAME ID Sales
---- ---------- -------

Eric          1  10,000
Eric          1  12,000
Ted           3  10,000
Jeff          2 null
Tad           4 null

Dave. Received on Wed Jul 28 2004 - 11:11:46 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US