title: Multiple Table Joins with Group_Concat where some records don't exist in all tables
body: <p>I am trying to do a fairly complex (for me) query that will grab a Description field from a Main Table and then append it with titles and values from related Look-Up-Tables. Not all records have records in the Look-up tables. I'll pose further questions as subsequent questions as I go along, but to start my issue is that only those records with values in all the tables show up.</p>
  
  <p><a href="http://sqlfiddle.com/#!9/09047/13" rel="nofollow noreferrer">http://sqlfiddle.com/#!9/09047/13</a></p>
  
  <ul>
  <li>(null)</li>
  <li>This is Record 2 Text<br><br><b>Color</b>:<br>Red<br><br><b>Fruit</b>:<br>Apple</li>
  <li>(null)</li>
  </ul>
  
  <p>If I use Concat_WS I get all records but my 'label' in the concat disappears:</p>
  
  <p><a href="http://sqlfiddle.com/#!9/09047/16" rel="nofollow noreferrer">http://sqlfiddle.com/#!9/09047/16</a></p>
  
  <ul>
  <li>This is Record 1 Text<br><br>Blue<br></li>
  <li>This is Record 2 Text<br><br>Red<br>Apple</li>
  <li>This is Record 3 Text<br><br><br>Grape</li>
  </ul>
  
  <p>So my first step is to get all the record descriptions regardless of how many Look-up-Tables they exist in and to get the Names/Labels displaying.</p>