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
Tad 4



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

select tablea.name,tablea.id,tableb.sales
from tablea,tableb
where tablea.id = tableb.id(+);

"Root" <root (AT) aol (DOT) com> wrote