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
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