What is the Microsoft Query Syntax for Subqueries?

Posted by Kuyenda on Stack Overflow See other posts from Stack Overflow or by Kuyenda
Published on 2010-05-10T16:11:39Z Indexed on 2010/05/10 16:14 UTC
Read the original article Hit count: 230

Filed under:
|
|

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.

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

Is there official documentation for Microsoft Query?

Thanks!

© Stack Overflow or respective owner

Related posts about excel

Related posts about sql