需要运行三个不使用union的select查询

SELECT column1, column2, column3
FROM table1
WHERE condition1
AND column1 IN (
    SELECT column1
    FROM table2
    WHERE condition2
)
AND column1 NOT IN (
    SELECT column1
    FROM table3
    WHERE condition3
);

CREATE TEMPORARY TABLE temp_table1 AS (
    SELECT column1, column2, column3
    FROM table1
    WHERE condition1
);

CREATE TEMPORARY TABLE temp_table2 AS (
    SELECT column1
    FROM table2
    WHERE condition2
);

CREATE TEMPORARY TABLE temp_table3 AS (
    SELECT column1
    FROM table3
    WHERE condition3
);

SELECT t1.column1, t1.column2, t1.column3
FROM temp_table1 t1
WHERE t1.column1 IN (
    SELECT t2.column1
    FROM temp_table2 t2
)
AND t1.column1 NOT IN (
    SELECT t3.column1
    FROM temp_table3 t3
);