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?
SELECT *
FROM (SELECT ID, Company FROM (`Sheet1$`)) AS a
INNER JOIN
(SELECT ID, Name FROM `Sheet1$`) AS b
ON a.ID = b.ID;
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.