title: PHP mySQL query, joining another table but need all rows to be fetched
body: <p>Bit more of a description:</p>
  
  <p>I've got a main table as an example</p>
  
  <pre><code>tblmain
  
  fldID | fldTitle | fldCompleted | fldCompleted2
  1     | Hello    | TRUE         | FALSE
  2     | World    | TRUE         | TRUE
  </code></pre>
  
  <p>Then I'm joining another table as follows</p>
  
  <pre><code>tbltojoin
  
  fldID | fldMainID | fldName | fldOrder | fldDeliver
  13    | 2         | Item 1  | TRUE     | TRUE
  14    | 2         | Item 2  | TRUE     | FALSE
  </code></pre>
  
  <p>I'm wanting to join these to show the false rows but also show the true row if the tblmain has some FALSEs in tbltojoin.</p>
  
  <p>So my desired output is as follows</p>
  
  <pre><code>World
  
  Name   | Completed | Completed 2 | Ordered | Delivered
  Item 1 | Yes       | Yes         | Yes     | Yes
  Item 2 | Yes       | Yes         | Yes     | No
  </code></pre>
  
  <p>Hopefully this makes sense, so even though I'm looking for FALSE items I still want the completed row from tbltojoin to show.</p>
  
  <p>I've tried various joins but I only end up managing to show FALSE results.</p>
  
  <p>If I've missed out any important info just let me know.</p>
  
  <p>Thanks!</p>