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;