select * from (select a.r1, a.r2,a.r3 from table1),(select b.r1, b.r2 from table2) 转载于:https://www.cnblogs.com/canyangfeixue/archive/2012/06/23/2559561.html