title: Is it possible to use subquery in join condition in Access?
body: <p>In postgresql I can use subquery in join condition</p>
  
  <pre><code>SELECT * 
  FROM table1 LEFT JOIN table2
       ON table1.id1 = (SELECT id2 FROM table2 LIMIT 1);
  </code></pre>
  
  <p>But when I try to use it in Access</p>
  
  <pre><code>SELECT *
  FROM table1 LEFT JOIN table2 
       ON table1.id1 = (SELECT TOP 1 id2 FROM table2);
  </code></pre>
  
  <p>I get syntax error. Is it actually impossible in Access or just my mistake?</p>
  
  <p><em>I know that I can get the same result with <code>WHERE</code>, but my question is about possibilities of <code>JOIN</code> in Access.</em></p>