Help with a Query

[Sripriya]

Hello Team,

I have 3 different tables in my Access DB. (2003)

Tables A, B and C.



A and B have a Id field to be used A.Id=B.Id.

Certain fields are to be selected from table A also.
Tables B and C are mapped using another field.
Now I need all the rows from table B whether there is related data in C or not and also where C.Id field= <some Value>.

Could someone help me with constructing a query for the same.. tried left join and it gives an error join not supported...

Thanking in advance.

Regards,
K. Sripriya

[June7]

Would have to know more about tables and relationships. If you want to provide db for analysis, follow instructions at bottom of my post.