title: Left outer join automatically add data to the parent table
body: <p>A normal </p>
  
  <pre><code>Select * from Customer;
  </code></pre>
  
  <p>yields me 1060 records with <code>customer ID 1064</code> at last.</p>
  
  <p>When I make a complex query </p>
  
  <pre><code>Select A,B,C,D 
  from customer 
  
  left outer join ...
  left outer join....
  left outer join....
  group by ...
  order by...
  </code></pre>
  
  <p>it yeilds me 1269 records. That is still fine with left outer join. But why is it adding the values to <code>customer ID</code> above 1060 (ie 1061-1269) which actually is not a data in <strong>customer</strong> table. Is there a rule ?</p>