title: MySQL subqueries multiple result
body: <p>Is it possible to make the code below work. At the moment it only show employees from "New York" but not employees from "Chicago".?</p>
  
  <pre><code>SELECT employees.ename, zipcodes.city
  FROM employees
  LEFT JOIN zipcodes
  ON employees.zip=zipcodes.zip
  WHERE employees.zip =
  (
  SELECT zipcodes.zip
  FROM zipcodes
  WHERE zipcodes.city = 'New York' OR 'Chicago'
  )
  ORDER BY employees.eno;
  </code></pre>
  
  <p>Thanks in advance!</p>
  
  <p>//René</p>