title: Left Join not returning all rows
body: <p>I have this query in MySQL:</p>
  
  <pre><code>SELECT pr.*, pr7.value AS `room_price_high`
  FROM `jos_hp_properties` pr
  LEFT OUTER JOIN `jos_hp_properties2` pr7 ON pr7.property=pr.id
  WHERE pr7.field=23
  </code></pre>
  
  <p>The <code>jos_hp_properties</code> table has 27 rows but the query only returns one. Based on <strong><a href="https://stackoverflow.com/questions/2479650/why-is-my-left-join-not-returning-nulls">this question</a></strong> I think it may be because of the WHERE clause. The <code>jos_hp_properties2</code> table has fields id, property, field, value, where <code>field</code> is a foreign key to a third table (which I don't need to get data from).</p>
  
  <p>Is there a way to select all the rows from the first table, including the value from table #2 where the field is 23 (or NULL if there is no field 23)?</p>