Results 1 to 2 of 2
  1. #1
    luckycharms is offline Novice
    Windows 7 Access 2007
    Join Date
    Sep 2010
    Posts
    8

    LEFT/RIGHT/OUTER JOINS in a set of subqueries

    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;

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,619
    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.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 02-02-2011, 01:00 PM
  2. Outer left join leaves out null values
    By mschles4695 in forum Queries
    Replies: 1
    Last Post: 12-22-2010, 11:43 PM
  3. Multiple outer joins - error message
    By Lipi in forum Queries
    Replies: 1
    Last Post: 09-16-2010, 02:44 PM
  4. Help With Left Joins
    By DaveyJ in forum Queries
    Replies: 23
    Last Post: 06-28-2010, 08:38 AM
  5. Examples of left joins?
    By narayanis in forum Queries
    Replies: 0
    Last Post: 06-14-2008, 06:17 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums