Re: problem with join

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.

--

Bill
.