title: SQL syntax on inner join two table after IN using MySQL
body: <p>I am having some trouble with the following sql query</p>
  
  <pre><code>SELECT c.item1 ,c.id, a.id
  FROM table_c as c
  WHERE c.id IN
    (
     SELECT id
     FROM table_b
     WHERE someinfo = 'active'
    )
  AND c.id IS NOT NULL
  INNER JOIN table_a as a
  ON c.id=a.id
  </code></pre>
  
  <p>The problem lies in the <code>INNER JOIN</code> </p>
  
  <pre><code>INNER JOIN table_a as a
  ON c.id=a.id
  </code></pre>
  
  <p>Sequel Pro outputs </p>
  
  <pre><code>You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INNER JOIN 
  </code></pre>
  
  <p>Can someone give me some insight on this</p>