title: Access left join on inner join
body: <p>I want to see everything in Table <code>a</code> that has non-relation to table <code>c</code></p>
  
  <p><code>a.id = b.Fid b.id = c.FID</code></p>
  
  <p>So I wanted to do <code>a</code> left join <code>a &amp; b</code> on <code>a</code> inner join <code>b &amp; c</code>; </p>
  
  <p>That does not work here</p>
  
  <pre><code>SELECT A.ID,
  
  FROM 
  A
  
  LEft JOIN
  (B
  INNER JOIN 
  C
  ON
  C.ID =B.FID) 
  ON
  B.ID = A.FID
  
  where 
  C.id is null
  </code></pre>