title: Unknown column issue with mysql alias subquery and MATCH
body: <p>I and trying to run a query that searches the same thing within 3 tables using MATCH and Subqueries Alias.</p>
  
  <p>Where is the query</p>
  
  <pre><code>SELECT 
      id, 
      name, 
      (SELECT TypeName FROM table2 WHERE id = table.id) AS type
  FROM table 
  WHERE 
      MATCH (name, type) AGAINST ('keyword1 keyword2')
  </code></pre>
  
  <p>Any Ideas how to solve it?</p>