title: INNER JOIN Returns Too Many Results
body: <p>I have the following SQL:</p>
  
  <pre><code>SELECT *
  FROM [Database].dbo.[TagsPerItem] 
  INNER JOIN [Database].dbo.[Tag] ON [Tag].Id = [TagsPerItem].TagId 
  WHERE [Tag].Name IN ('home', 'car') 
  </code></pre>
  
  <p>and it returns:</p>
  
  <pre><code>Id TagId  ItemId ItemTable Id Name  SiteId
  ------------------------------------------
  1  1      1      Content   1  home  1
  2  1      2      Content   1  home  1
  3  1      3      Content   1  home  1
  4  2      4      Content   2  car   1
  5  2      5      Content   2  car   1
  6  2      12     Content   2  car   1
  </code></pre>
  
  <p>instead of just two records, which these names are "home" and "car". How can I fix it? </p>
  
  <p>Thanks.</p>