Query to get all Data in One Table, Matching of Another

[DariceLR]

... Thanks in advance...
I have two tables:
Member Table
(Primary Key: MemberID)
Fname
Mname
Lname
...

AddressTable
(Primary Key is MemberID and AddressType)
AddressType
Address
City
State
Zip
...


What I need is to get all the columns of table Member and if there is a matching child record in Address show it, otherwise just show the member data. I can only think of the way to join that gives me only the members that have address information, but I need all members, regardless if they have Address Information.

Can you help? ****************
DariceLR
:-{} :-V
****************

 

[swampBoogie]

select * from member left outer join address
on member.memberid = address.memberid

 

[mwolf00]

SELECT m.fName, m.lName, a.address, a.city, a.state
FROM members m
LEFT JOIN address a ON m.memberID = a.memberID Get the Best Answers! faq333-2924
Is this an asp FAQ? faq333-3048

mikewolf@tst-us.com