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
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