title: SQL Server - IN clause with multiple fields
body: <p>Is it possible to include in a <code>IN</code> clause multiple fields? Something like the following:</p>
  
  <pre><code>select * from user
  where code, userType in ( select code, userType from userType )
  </code></pre>
  
  <p>I'm using ms sql server 2008</p>
  
  <hr>
  
  <p>I know this can be achieved with joins and exists, I just wanted to know if it could just be done with the <code>IN</code> clause.</p>