执行多个select语句以使用Case语句在where条件中选取一个值

SELECT column1, column2
FROM table
WHERE column3 = (
    CASE
        WHEN condition1 THEN (SELECT value1 FROM table1)
        WHEN condition2 THEN (SELECT value2 FROM table2)
        ELSE (SELECT value3 FROM table3)
    END
);

CREATE TEMPORARY TABLE temp_table (
    value1 INT,
    value2 INT,
    value3 INT
);

INSERT INTO temp_table (value1, value2, value3)
VALUES (SELECT value1 FROM table1), (SELECT value2 FROM table2), (SELECT value3 FROM table3);

SELECT column1, column2
FROM table
WHERE column3 = (
    CASE
        WHEN condition1 THEN (SELECT value1 FROM temp_table)
        WHEN condition2 THEN (SELECT value2 FROM temp_table)
        ELSE (SELECT value3 FROM temp_table)
    END
);