Pass-Through and Access Query

[thegameoflife]

Ok in the code below SERVICES is SQL Table and QR_Serv_Not_00 is an Access Query. What do I need to change to make this work?

SELECT SERVICES.SERVICE_NUM, SERVICES.CLAIM_NUM, 
FROM SERVICES INNER JOIN QR_Serv_Not_00 ON (SERVICES.CLAIM_NUM = QR_Serv_Not_00.CLAIM_NUM) AND (SERVICES.SERVICE_NUM = QR_Serv_Not_00.SERVICE_NUM);

 

[tomschafer]

Use A Pass-Through Query to hit your SQL tables. Then include that query as a seperate "table" in a regular select query.

Something like...

Pass-Through Query Named Pezs:

SELECT SERVICES.SERVICE_NUM, SERVICES.CLAIM_NUM,
FROM SERVICES

Access Query:

SELECT * FROM Pezs INNER JOIN QR_Serv_Not_00 ON (Pezs.CLAIM_NUM = QR_Serv_Not_00.CLAIM_NUM) AND (Pezs.SERVICE_NUM = QR_Serv_Not_00.SERVICE_NUM);