title: mysql SELECT FROM two tables and LEFT JOIN
body: <p>I have problem with select from two tables and left join to third. Query:</p>
  
  <pre><code>SELECT 
      c.id AS currency, u.user, us.enabled AS currency 
  FROM 
      users AS u, 
      currency AS c
      LEFT JOIN users_settings AS us ON(c.id=us.currency, u.user=us.user)
  WHERE 
      c.off=0 AND c.disabled=0 AND c.status=1 
  </code></pre>
  
  <p>Error:</p>
  
  <blockquote>
    <p><code>#1054</code> - Unknown column 'u.user' in 'field list'</p>
  </blockquote>
  
  <p>I need Cartesian product of users and currency. 
  Users: id, login, email, pass </p>
  
  <p><a href="http://en.wikipedia.org/wiki/Cartesian_product" rel="nofollow">http://en.wikipedia.org/wiki/Cartesian_product</a></p>