T-SQL - 如何编写查询以获取与多对多连接中的所有记录匹配的记录

SELECT *
FROM Table1
INNER JOIN Table2
ON Table1.ID = Table2.ID
INNER JOIN Table3
ON Table1.ID = Table3.ID

SELECT *
FROM Table1
FULL OUTER JOIN Table2
ON Table1.ID = Table2.ID
FULL OUTER JOIN Table3
ON Table1.ID = Table3.ID

SELECT *
FROM Table1
CROSS JOIN Table2
CROSS JOIN Table3

SELECT *
FROM Table1
UNION
SELECT *
FROM Table2
UNION
SELECT *
FROM Table3

SELECT *
FROM Table1
WHERE EXISTS (SELECT * FROM Table2 WHERE Table1.ID = Table2.ID)
AND EXISTS (SELECT * FROM Table3 WHERE Table1.ID = Table3.ID)