Access 2010:连接三个表,未知错误 [英] Access 2010: Joining three tables, unknown error
本文介绍了Access 2010:连接三个表,未知错误的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我正在尝试通过SQL查询将MS Access 2010中的三个表联接起来.
I am trying to join three tables in MS Access 2010 in a SQL query.
SELECT Track.trackName, TrackIsGenre.genre, ContainsTracks.albums
FROM Track
INNER JOIN TrackIsGenre ON Track.trackName = TrackIsGenre.track
INNER JOIN ConstainsTracks ON Track.trackName = ContainsTracks.tracks
WHERE genre = "Rock"
ORDER BY trackName ASC;
我搜索了网络,据我所知应该是这样.我可以加入两个表没问题.我得到的错误是:查询表达式中的语法错误(缺少运算符)",它突出显示了两个INNER JOIN.
I searched the net and as far as I can see this should be it. I can JOIN two tables no problem. The error I get is: "Syntax error (missing operator) in query expression" and it highlights the two INNER JOIN.
任何帮助将不胜感激.
推荐答案
在您首次加入时添加括号,(在MOST RDBMS上是可选的)
Add a parenthesis on you first join, (this is optional on MOST RDBMS)
SELECT Track.trackName, TrackIsGenre.genre, ContainsTracks.albums
FROM (Track INNER JOIN TrackIsGenre ON Track.trackName = TrackIsGenre.track)
INNER JOIN ConstainsTracks ON Track.trackName = ContainsTracks.tracks
WHERE genre = "Rock"
ORDER BY trackName ASC;
这篇关于Access 2010:连接三个表,未知错误的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文