是否可以在MS-Access中进行3表联接? [英] Is it possible to do a 3 table join in MS-Access?

问题描述

我尝试在Access中进行3表联接，但是它不起作用.是否有可能?

I try to do a 3-table join in Access and it will not work. Is it possible?

推荐答案

MS-Access/Jet允许使用其他类型的SQL提供的所有各种类型的多表联接.例如，这是一个简单的三表层次结构示例(比此处的其他答案要真实得多):

All the various types of multi-table joins that are available in other flavour of SQL are permitted in MS-Access/Jet. For example, here's a straight three-table hierarchical example (a bit more real-world than the other answers here):

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

还是您想知道如何使用MS-Access中的Visual Designer来做到这一点?

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

这篇关于是否可以在MS-Access中进行3表联接?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！