title: JOIN three tables
body: <p>I am trying to retrieve two sets of information (the red and blue portions of the diagram in the one query.</p>
  
  <p>I thought I could do it using the sql as stated below but it does not return me anything when TableC has no records. If TableC has no records, I would still want this query to return me the results as indicated by the BLUE area.</p>
  
  <blockquote>
    <p>SELECT A.* FROM TableA A</p>
    
    <p>JOIN TableB B ON (A.id = B.a_id)</p>
    
    <p>JOIN TableC C ON (A.id = C.a_id)</p>
  </blockquote>
  
  <p>Appreciate any pointers to return me the red and/or blue segments. Thanks in advance  =]</p>