[MSSQL] 오라클 다중 IN => MSSQL 구현

오라클 코드

SELECT * FROM TEMPA 
WHERE (A, B) IN (SELECT A, B FROM TEMPB WHERE C ='Y')

DELETE FROM TEMPA WHERE (A, B) IN ( SELECT A, B FROM TEMPB WHERE C = 'Y' )

SELECT A, B, C, D
FROM TABLE_A
WHERE (A, B) IN 
(
       SELECT BB.A, CC.B 
       FROM TABLE_B BB, TABLE_C CC
       WHERE BB.A = CC.A
)

MSSQL 코드

SELECT A.* FROM TEMPA A
WHERE EXISTS (SELECT 1 FROM TEMPB B WHERE B.A = A.A AND B.B. = A.B AND C = 'Y' )

DELETE FROM TEMPA 
WHERE EXISTS (SELECT 1 FROM TEMPB B WHERE B.A = TEMPA.A AND B.B. = TEMPA.B AND C = 'Y' )

SELECT A, B, C, D
FROM TABLE_A AA JOIN
(
       SELECT BB.A, CC.B
       FROM TABLE_B BB JOIN TABLE_C CC ON BB.A = CC.A
)
AAA ON  AA.A = AAA.A AND AA.B = AAA.B

끝~