title: Combination of table left join to an inner join in mysql
body: <p>Lets say, I have 3 tables, cars, cars_owner and owner.
  Now I want to have the complete list of cars, those that do have owners and those that don't.</p>
  
  <p>When a car has an own, I must have the data of the owner.</p>
  
  <pre><code>Wrong query 1 (selects ownerless cars out): 
  SELECT * FROM car 
  LEFT JOIN cars_owner ON ...
  INNER JOIN owner ON ...
  
  Wrong query 2 (selects cars_owner relations without owners too): 
  SELECT * FROM car 
  LEFT JOIN cars_owner ON ...
  LEFT JOIN owner ON ...
  </code></pre>
  
  <p>The question ist: How to left join a table with an inner join in mysql? Any ideas?</p>