Re: problem with join

Vitali Kalinin wrote:


Something like this should work:
select Mbr.CAPID, Mbr.NameLast, Mbr.NameFirst, Mbr.NameMiddle,
Mbr.NameSuffix, MbrAddr.CAPID, MbrAddr.Addr1, MbrAddr.Addr2,
MbrAddr.City,
MbrAddr.[State], MbrAddr.Zip
from Member Mbr
LEFT OUTER JOIN MbrAddresses MbrAddr on (Mbr.CAPID=MbrAddr.CAPID)

Thank you! No more error message!

And better still, I learned something.

--

Bill
.