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 -> help with join

help with join

From: Root <root_at_aol.com>
Date: Wed, 28 Jul 2004 15:35:51 GMT
Message-ID: <rJPNc.99313$4I.7137@newssvr29.news.prodigy.com>


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? Received on Wed Jul 28 2004 - 10:35:51 CDT

Original text of this message

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