Microsoft Query 的子查询语法是什么? [英] What is Subqueries syntax for Microsoft Query?

问题描述

我正在尝试在 Microsoft Query 中进行简单的子查询联接，但我无法弄清楚语法.我也找不到有关语法的任何文档.

I am trying to do a simple subquery join in Microsoft Query, but I cannot figure out the syntax. I also cannot find any documentation for the syntax.

我将如何在 Microsoft Query 中编写以下查询?

How would I write the following query in Microsoft Query?

SELECT *
FROM (
    SELECT Col1, Col2
    FROM `C:\Book1.xlsx`.`Sheet1$`
) AS a
JOIN (
    SELECT Col1, Col3
    FROM `C:\Book1.xlsx`.`Sheet1$`
) AS b
ON a.Col1 = b.Col1

是否有 Microsoft Query 的官方文档?

Is there official documentation for Microsoft Query?

推荐答案

SELECT * 
    FROM (SELECT ID, Company FROM (`Sheet1$`)) AS a 
    INNER JOIN 
    (SELECT ID, Name FROM `Sheet1$`) AS b 
    ON a.ID = b.ID;

这对我有用.看起来唯一的区别是 INNER JOIN 与 JOIN.我的字段是 ID、公司、名称，按 Col1、Col2、Col3 的顺序排列.

That worked for me. It looks like the only difference is INNER JOIN vs. JOIN. My fields are ID, Company, Name in that order for Col1, Col2, Col3.

这篇关于Microsoft Query 的子查询语法是什么?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！