LEFT/RIGHT/OUTER JOINS in a set of subqueries

[luckycharms]

Hi Folks,

I have the following query, and i'm getting errors about access not supporting the JOIN. I know I can't embed inner joins within outer joins. But what about right and left joins? When I make them all INNER JOINS or LEFT JOINS, access doesn't complain. If I make them all RIGHT JOINS, or mix them up (as I'd like), Access complains. Any ideas?

thanks in advance...

SELECT s.*, sn.SurvT, sn.CE, sn.SD, sn.Dec, sn.Tapr, sf.*
FROM ((Species s LEFT JOIN species_abundances sa ON s.ID = sa.SpeciesID)
RIGHT JOIN Lars_seedling_morph_nursery_data_Biotropica sn ON s.ID = sn.SpeciesID)


RIGHT JOIN Lars_Seedling_Morph_Field_Data_JEcology sf ON s.ID = sf.SpeciesID;

[June7]

Why do you want to? Apparently, nature of table relationships won't allow this. Would need to know more about your data structure and what you are trying to accomplish.