title: SQL Inner Outer Join confusion
body: <p>I'm having a little confusion with a certain example. </p>
  
  <p>I am supposed to list all orders and their corresponding details. </p>
  
  <p>This is what I'm doing:</p>
  
  <pre><code>SELECT *
      FROM Orders 
      LEFT OUTER JOIN [Order Details]
      ON Orders.OrderID=[Order Details].OrderID;
  </code></pre>
  
  <p>This gives the number of rows = 2155. </p>
  
  <p>Now the problem is, the number of rows in Orders Table is 830...how can left outer join create more rows ?</p>
  
  <p>By definition of left outer join, all the rows from the left table are taken and matching records from the second table are added. </p>
  
  <p>I checked the number of rows in the Order Details table..that is 2155. </p>
  
  <p>Why is left outer join using all rows from Order Details table? </p>