Re: problem with join


"William Meyer" <meyer.wil@xxxxxxxxx> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ:
news:48174704$1@xxxxxxxxxxxxxxxxxxxxxxxxx
Vitali Kalinin wrote:

You have to quote like this: MA.[State]

Thanks!

But, I still have a problem. And unfortunately, the error message says
only that there is a problem with the JOIN.

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, MbrAddresses MbrAddr
LEFT JOIN MbrAddresses on Member.CAPID=MbrAddresses.CAPID

I've tried to do it without aliases, as well, and it makes no
difference.
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)


.