将两个表的结果合并为一个(MS Access)

Question

在我的项目中，我试图根据示例将两个表(T1和T2)组合成查询。

表T1:

id_order | id_client | amount
1     |     10    |   5
2     |     10    |  12
3     |     11    |   7

表T2:

id_client| First_name| Last_name
10    |     A     |    V
11    |     N     |    K
12    |     G     |    W

结果:

id_order | id_client | First_name| Last_name
1     |     10    |    A      |     V
2     |     10    |    A      |     V
3     |     11    |    N      |     K

我的代码看起来像这样，但它似乎不工作:

SELECT [id_order], [id_client] FROM T1 ORDER BY [id_order]
UNION SELECT [First_name], [Last_name] FROM T2
WHERE T1.id_order = T2.id_order;

有人能帮忙吗?

Answer 1

考虑:

SELECT id_order, T2.id_client, First_name, Last_name 
FROM T2 INNER JOIN T1 
ON T2.id_Client = T1.id_Client
ORDER BY T1.id_order;

根据您的数据和您想要检索的内容，可能需要LEFT或RIGHT而不是INNER。

使用Access查询生成器帮助获得正确的语法。它会自动添加括号。