mysql - 将多个查询的输出合并为一个

Question

1.select col1,col2 from table1 where condition1=<<value1>>
UNION ALL 
select col1,col2 from table2 condition1=<<value2>>;

2. `select col1 from table3;`

3. I need to write the 3rd query where i need the output of col1,col2 from table1 based on the col1 (sort based on col1 from table3).

我可以这样做

create table as temp_table as
select col1,col2 from table1 where condition1=<<value1>>
UNION ALL 
select col1,col2 from table2 condition1=<<value2>>;

SELECT t1.col1,t1.col2
FROM temp_table t1
LEFT OUTER JOIN table3 t2 ON t1.col2=t2.col2
order by t2.col1;

我想在单个查询中(在 mysql 中)而不是使用临时表。

有什么想法吗？谢谢。

Answer 1

您可以将联合结果用作子选择。