title: How to select records that have multiple values in a related table?
body: <p>I have the following three tables for tagging content where each content can have one-to-many tags. For example, a content record could have a tag of California and Variable.</p>
  
  <p>Table w/ the content</p>
  
  <pre><code>Content
  -ContentID
  -ContentName
  </code></pre>
  
  <p>Table w/ the tags</p>
  
  <pre><code>Tag
  -TagID
  -TagName
  </code></pre>
  
  <p>Table that links the content and the tags</p>
  
  <pre><code>ContentTag
  -ContentID
  -TagID
  </code></pre>
  
  <p>With the following SELECT statement I want to get records with TagID of both 21 and 54 however no rows are returned.</p>
  
  <pre><code>SELECT * FROM ContentTag
  INNER JOIN Content On ContentTag.ContentID=Content.ContentID
  INNER JOIN Tag ON ContentTag.TagID=Tag.TagID
  Where (Tag.TagID=21 And Tag.TagID=54)
  </code></pre>
  
  <p>How do I create a SQL SELECT statement to retrieve content that has one-to-many tags?</p>