title: Inner join between two tables with same count values
body: <p>I have been working on this issue since 2 days now.</p>
  
  <p>I have two tables created by using SQL Select statements</p>
  
  <pre><code>SELECT (
  
  
  ) Target
  
  INNER JOIN
  
  SELECT (
  
  
  ) Source
  
  ON Join condition 1
  AND Join condition 2
  AND Join condition 3
  AND Join condition 4
  AND Join condition 5
  </code></pre>
  
  <p>The target table has count value of 10,000 records.
  The source table has count value of 10,000 records.</p>
  
  <p>but when I do an inner join between the two tables on the 5 join conditions</p>
  
  <p>I get 9573 records.</p>
  
  <p>I am basically trying to find a one to one match between source and target table. I feel every field from target matches every field in source.</p>
  
  <p>Questions: </p>
  
  <ol>
  <li>Why does my inner join give less records even if there are same value of records in both tables?</li>
  <li>If it is expected, how can I make sure I get the exact 10,000 records after the join condition?</li>
  </ol>