title: select from LEFT OUTER JOIN
body: <p>I have a table called DICT that have a foreign key on table applicant and other table called DT.</p>
  
  <p>The table DT has a foreign key into table applicant.</p>
  
  <p>What I want to do is to select:</p>
  
  <ul>
  <li>DICT.*</li>
  <li>the applicant related to the DICT</li>
  <li>the  DT related to the DICT and the applicant related to this DT</li>
  </ul>
  
  <p>I have this incomplete code </p>
  
  <pre><code>SELECT DICT.*,DT.*,applicant.*
  FROM DICT
  LEFT OUTER JOIN DICT.dt = DT.id_DT 
  INNER JOIN applicant  ON DICT.applicant =applicant .id_applicant 
  WHERE DICT.id_DICT = 5
  </code></pre>
  
  <p>I have to use <code>LEFT OUTER JOIN</code> on DT because some time DICT don't have DT
  and this code give DICT, their linked applicant record and DT but it don't give the applicant related to the DT.</p>