* Oracle Multi In 절 MSSQL로 처리하기.
# Oracle
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
)
# SQL Server
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