title: Multiple inner joins with different where-conditions
body: <p>I am currently using the following query to perform a search across multiple tables via INNER JOIN.</p>
  
  <pre><code>    SELECT title, m2.txt1 AS teaser, inputdat, db_file.*
         FROM db_item 
              INNER JOIN db_itemv AS m1 USING(id_item) 
              INNER JOIN db_itemf USING(id_item) 
              INNER JOIN db_itemd USING(id_item) 
              INNER JOIN db_itemv AS m2 USING(id_item)
         WHERE type=15 AND m1.fldnr='12' 
  AND m1.indik='b' AND m1.txt1s='en'
   AND visibility=0 AND inputdat&gt;'2005-11-02' AND m2.fldnr='123'
         GROUP BY title
         ORDER BY inputdat DESC
         LIMIT 0,100
  </code></pre>
  
  <p>The columns of db_itemv (m1, m2) are named:</p>
  
  <pre><code>ID   id_item   fldnr   indik   txt1
  </code></pre>
  
  <p>One id_item may exist on several rows.</p>
  
  <p>My problem is, that m2.fldnr='123' does not always exist and therefore it kicks out the whole row. But I want to keep the row and keep the column empty when it doesn't exist in the row. How can I solve the problem? </p>