不使用任何union子句的SQL

SELECT column1, column2
FROM table1
WHERE column1 IN (SELECT column1 FROM table2)

SELECT table1.column1, table2.column2
FROM table1
JOIN table2 ON table1.column1 = table2.column1

CREATE TEMPORARY TABLE temp_table (column1 datatype, column2 datatype);

INSERT INTO temp_table (column1, column2)
SELECT column1, column2 FROM table1;

INSERT INTO temp_table (column1, column2)
SELECT column1, column2 FROM table2;

SELECT column1, column2 FROM temp_table;