I have four tables; ES, ED, RC and

[gny]

I have four tables; ES, ED, RC and CA.
I need to make the following joins in a query:

ED -- ES
ES -- RC
CA -> ES

I.e. I always want all records from CA returned.
I know i can make the inner joins first as a separate query,
but does anyone know if there is a way to construct this as a single query? I need this since i will run it from an ASP page.

I tried to make the inner joins in a separate query as below, which worked fine in Access, but when i tried to run that query from the ASP i got an error.

SELECT *
FROM CA_CheckAddress LEFT JOIN ED_ES_RC_Joined ON CA_CheckAddress.CA_ID = ED_ES_RC_Joined.ES_CA_ID;

 

[gny]

Sorry about the non-descriptive subject line...i forgot to write one...