视图
create view v_table as
select t1.* from table1 t1
union all
select t2.* from table2 t2;

select * from v_table;

你要的是这样的吧?