title: Need to understand how Multiple joins - Left Outer, Right outer, Full outer joins work in a single SQL Query
body: <p>I have four tables - A,B,C,D. Each table has 1 column: <code>ID</code>. </p>
  
  <p>Data:</p>
  
  <pre><code>Table A = 1,2,3,4
  Table B = 1,2,4,5
  Table C = 2,3,4,5
  Table D = 1,3,5,7
  </code></pre>
  
  <p>I need help in understanding the output of this SQL query:</p>
  
  <pre><code>select d.*, c.*, b.*,a.* 
  from d 
    left join c on d.id = c.id 
    right join b on b.id = c.id 
    full outer join a on a.id = b.id;
  </code></pre>
  
  <p>I am very clear till the left join, but after that when the subsequent joins are applied, I do not understand how the result changes.</p>