title: What is Subqueries syntax for Microsoft Query?
body: <p>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.</p>
  
  <p>How would I write the following query in Microsoft Query?</p>
  
  <pre><code>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
  </code></pre>
  
  <p>Is there official documentation for Microsoft Query?</p>