Can I combine join types in MS Access

Posted on 2009-12-21
Last Modified: 2012-05-08
In MS SQL Server I can Have an inner join between 2 tables then a left join between two tables, if i attempt this in access i get the error message..

Question by:Jimmy_inc
    LVL 8

    Assisted Solution

    LVL 57

    Accepted Solution

    You need an additional () between each operations like

    -- For three tables
    FROM (tabe1 INNER JOIN table2 ON table1.col1 = table2.col2)
    INNER JOIN tab3 ON table2.col2 = table3.col3;

    -- For Four tables

    FROM ((tabe1 INNER JOIN table2 ON table1.col1 = table2.col2)
    INNER JOIN table3 ON table2.col2 = table3.col3)
    INNER JOIN table4 on table3.col4 = table4.col2;

    An example given here..

    Author Closing Comment

    Thanks. I've realised I should of read the error msg in the first place.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    Suggested Solutions

    As they say in love and is true in SQL: you can sum some Data some of the time, but you can't always aggregate all Data all the time! Introduction: By the end of this Article it is my intention to bring the meaning and value of the above quote to…
    Confronted with some SQL you don't know can be a daunting task. It can be even more daunting if that SQL carries some of the old secret codes used in the Ye Olde query syntax, such as: (+)     as used in Oracle;     *=     =*    as used in Sybase …
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now