sql-server - SQL WHERE.. IN 子句多列

Question

我需要在 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
)

但是 WHERE..IN 子句只允许 1 列。如何将 2 列或更多列与另一个内部 SELECT 进行比较？

Answer 1

您需要使用 WHERE EXISTS 语法。

SELECT *
FROM table1
WHERE EXISTS (SELECT *
              FROM table2
              WHERE Lead_Key = @Lead_Key
                        AND table1.CM_PLAN_ID = table2.CM_PLAN_ID
                        AND table1.Individual_ID = table2.Individual_ID)