再补充一条吧,如果过滤了 ,可以使用下面的方法:

select a from (select * from (select 1 `a`)m join (select 2 `b`)n join (select 3 `c`)t where 0 union select * from table2)x;