ACCESS 2007 Join statement

Question

I am not sure how to write this join statement. I tried it a few different ways with various errors.

I get the error "ODBC--connection to 'MYCONN' failed."

SELECT ad.ad_addr
FROM 
    PUB_cm_mstr AS cm 
    INNER JOIN 
    (
        PUB_ad_mstr AS ad 
        INNER JOIN 
        PUB_BusinessRelation AS br 
            ON ad.ad_ref = br.BusinessRelationCode
    ) 
        ON cm.cm_addr = br.BusinessRelationName2;

There's no reference to MYCONN in that string. Perhaps MYCONN isn't set up properly? — Johnny Bones

joe joe · Accepted Answer · 2013-06-26T19:35:50

My solution which i did not love was to have two sources and then merge join them together to get the information I needed.

ACCESS 2007 Join statement

1 Answers