title: Aliases for 2 joins on one table in Microsoft Access
body: <p>I have a table that shows relationships between items and another table with the items themselves:</p>
  
  <pre><code>articles_to_articles
  -------------------------
  |articleID_1|articleID_2|
  -------------------------
  |12345      |67890      |
  |23442      |343243     |
  -------------------------
  
  articles
  -----------------------------------------------------
  |article_id | article_name|lots | of | other | stuff|
  -----------------------------------------------------
  </code></pre>
  
  <p>I am attempting to generate a file with that consists of the relationships from <code>articles_to_articles</code> but with the names in addition to the ids.
  What I have so far is:</p>
  
  <pre><code>    SELECT
      a2a.articleID_1,
      key_articles.article_name,
      a2a.articleID_2,
      val_articles.article_name 
  FROM
      articles_to_articles a2a
  INNER JOIN
      articles key_articles 
          ON key_articles.articleID = articles_to_articles.articleID_1 
  INNER JOIN
      articles val_articles 
          ON val_articles.articleID = articles_to_articles.articleID_2;
  </code></pre>
  
  <p>Access gives me a "missing operator" error but I can't seem to find the missing operator. What basic thing am I missing?</p>