title: Multiple conditions on the same column in the WHERE clause
body: <p>I have a table something like this - </p>
  
  <pre><code>RecordID   PropertyID       PropertyVal
  --------------------------------------------------
  3215            7           john doe
  3215            11          Chicago
  3215            13          Business Development Analyst
  3216            7           jane doe
  3216            11          Chicago
  3216            13          Managing Director
  3217            7           mike smith
  3217            11          Chicago
  3217            13          Business Development Analyst
  3218            7           john smith
  3218            11          Seattle
  3218            13          Managing Director
  </code></pre>
  
  <p>How do I return the names of users where <code>PropertyID = 13 AND PropertyVal='Business Development Analyst'AND PropertyID = 11 AND PropertyVal = 'Chicago'</code>. How do I do multiple where clauses for the same column?</p>
  
  <p>Edit:
  I need the result set to look like this -</p>
  
  <pre><code>Name
  ----
  John Doe
  Mike Smith
  </code></pre>