title: MySQL left join subquery fail
body: <p>Following query runs well in MySQL 5.x</p>
  
  <pre><code>SELECT
    m_area.id, m_area.cn_areaName, m_area.de_areaName,
    m_area.en_areaName,m_area.jp_areaName,t_shop.count
  FROM
    m_area left join   
  (
  select t_shop.areaID, count(areaID) AS count
  from t_shop
  group by t_shop.areaID
  ) t_shop
  on m_area.id = t_shop.areaID
  </code></pre>
  
  <p>However, when I have to run it in a 4.0.23 MySQL DB with same DB structure and data it just return following message:</p>
  
  <blockquote>
    <h1>1064 - 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 '[</h1>
  
  <pre><code>            select t_shop.areaID, count(areaID) AS count
              from t_s 
  </code></pre>
  </blockquote>
  
  <p>I tried many times but still failed. Is left join to subquery not allowed in MySQL 4.x ? Then that mean I have to do it with a temp table?</p>
  
  <p>Thanks in advance!</p>