Is it possible to do a 3 table join in MS-Access?

Question

I am trying to do a 3-table join in Access and it is not working.

Will it be possible?

Answer 1

All the several types of multi-table joins that are available in other flavours of the SQL are allowed in the MS-Access/Jet. 

For example, here is a straight three-table hierarchical example :

SELECT
    x.FirstName,
    x.Surname,
    r.RegionName,
    c.CountryName
FROM
    (Customer x LEFT JOIN Region r
    ON r.ID=x.RegionID)
    LEFT JOIN Country c
    ON c.ID=r.CountryID

Or do you want to know how to do it using the Visual Designer in the MS-Access?

Want to learn more concepts related to SQL? Join this SQL Course by Intellipaat.