help with join

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