Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: help with join
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