title: Mysql show rows as null if not exists at the child
body: <p>The result of the query</p>
  
  <pre><code>SELECT CFV.VALUE, CF.NAME
  FROM CONTACTFIELD CF LEFT JOIN
       CONTACTFIELDVALUE CFV
       ON CF.ID = CFV.FIELDID AND CF.ORID = CFV.ORID
  WHERE CFV.CONTACTID = 81 AND CFV.ORID = 976 
  </code></pre>
  
  <p>is </p>
  
  <pre><code>Value Name
  22    fld1 
  33    fld2
  44    fld3 
  </code></pre>
  
  <p>The CONTACTFIELD has 5 rows</p>
  
  <p>fld1
  fld2
  fld3
  fld4
  fld5</p>
  
  <p>So I want my query return null if the value not exists eg:</p>
  
  <pre><code>Value Name
  22    fld1 
  33    fld2
  44    fld3 
  null  fld4 
  null  fld5 
  </code></pre>
  
  <p>How can I manage this? Thank you!</p>