Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
in SQL by (6.1k points)
I am trying to do a 3-table join in Access and it is not working.

Will it be possible?

1 Answer

0 votes
by (12.7k points)
edited by

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.

Browse Categories

...