SQL Server -在没有父表的情况下连接三个表的更有效方法

SELECT *
FROM table1
WHERE column1 IN (
    SELECT column1
    FROM table2
    WHERE column2 = 'value'
) AND column3 IN (
    SELECT column3
    FROM table3
    WHERE column4 = 'value'
);

CREATE TABLE #temp (
    column1 datatype,
    column2 datatype,
    column3 datatype
);

INSERT INTO #temp
SELECT table1.column1, table2.column2, table3.column3
FROM table1
JOIN table2 ON table1.column1 = table2.column1
JOIN table3 ON table2.column2 = table3.column2
WHERE table1.column4 = 'value';

SELECT *
FROM #temp
WHERE column3 = 'value';

DROP TABLE #temp;