title: MySQL AND vs OR condition
body: <p>I am trying to get a collection from a main table that meets the condition of a child table. what I am trying is this:</p>
  
  <pre><code>SELECT main_table.* 
  FROM main_table 
  LEFT OUTER JOIN category_available ON main_table.id = category_available.main_table_id 
  WHERE  category_available.category_id = 206 AND category_available.category_id = 207;
  </code></pre>
  
  <p>I get no results even though the main table contains a row that has entries that meet both the AND conditions from the child table. If I substitute the AND for an OR I get expected results, but the query needs to meet the AND condition.</p>
  
  <p>category_available is a child table. It contains many rows that can be tied to a single main table row. So it might contain two rows that contain the main_table id, one with an id of 206 and another with 207. So i need to return the main_table row(s) that meet both conditions.</p>