SQL WHERE.. IN clause multiple columns
Posted
by ala
on Stack Overflow
See other posts from Stack Overflow
or by ala
Published on 2009-07-16T07:39:46Z
Indexed on
2010/04/19
17:13 UTC
Read the original article
Hit count: 209
Filed under:
sql-server
|query
i need to implement the following query in SQL Server
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
)
but the WHERE..IN clause allows only 1 column. How to compare 2 or more columns with another inner select?
© Stack Overflow or respective owner
