title: Adding more joins to a select
body: <p>I am having some trouble trying to add 2 more joins to a select. The bellow works for me:</p>
  
  <pre><code>FROM
      TABLE1 A
  INNER JOIN TABLE2 B ON A.ID = B.ID
  LEFT JOIN TABLE3 C ON A.REQUESTED_BY = C.USER_NAME
  LEFT JOIN TABLE3 D ON A.COORDINATOR = D.USER_NAME
  INNER JOIN TABLE4 E ON A.ID = E.PARENT_ID
  INNER JOIN TABLE5 F ON E.ID = F.ID
  </code></pre>
  
  <p>But I need to get more information, so I tried something like this (added the last 2 rows):</p>
  
  <pre><code>FROM
      TABLE1 A
  INNER JOIN TABLE2 B ON A.ID = B.ID
  LEFT JOIN TABLE3 C ON A.REQUESTED_BY = C.USER_NAME
  LEFT JOIN TABLE3 D ON A.COORDINATOR = D.USER_NAME
  INNER JOIN TABLE4 E ON A.ID = E.PARENT_ID
  INNER JOIN TABLE5 F ON E.ID = F.ID
  INNER JOIN TABLE6 G ON A.ID = B.ID
  LEFT JOIN TABLE3 H ON G.COORDINATOR = H.USER_NAME
  </code></pre>
  
  <p>And this isn't working like it should. </p>
  
  <p>Question: How can I add the last two joins to make the select works? Thanks.</p>