title: SQL WHERE.. IN clause multiple columns
body: <p>I need to implement the following query in SQL Server:</p>
  
  <pre><code>select *
  from table1
  WHERE  (CM_PLAN_ID,Individual_ID)
  IN
  (
   Select CM_PLAN_ID, Individual_ID
   From CRM_VCM_CURRENT_LEAD_STATUS
   Where Lead_Key = :_Lead_Key
  )
  </code></pre>
  
  <p>But the WHERE..IN clause allows only 1 column. How can I compare 2 or more columns with another inner SELECT?</p>