タグ: SQL Server 同じテーブル 何度も 結合

SELECT T1.ID, T21.b, T22,b
    FROM Table1 AS T1
        INNER JOIN Table2 AS T21 ON T1.ID = T21.ID
        INNER JOIN Table2 AS T22 ON T1.ID = T22.ID
    WHERE T21.a = 1
        AND T22.a = 2