SQL避免使用子查询中的多部分标识符

SELECT t1.column_name
FROM table1 t1
WHERE t1.column_name IN (
    SELECT t2.column_name
    FROM table2 t2
)

SELECT t1.column_name
FROM table1 t1
INNER JOIN table2 t2 ON t1.column_name = t2.column_name

CREATE TEMPORARY TABLE temp_table AS (
    SELECT column_name
    FROM table2
);

SELECT t1.column_name
FROM table1 t1
INNER JOIN temp_table tt ON t1.column_name = tt.column_name;