这些表的结构都是完全一样的。
select * from
(select * from A
union all
select * from B
union all
select * from C
union all
select * from D
union all
select * from E) tb where td.name='abc' 最佳答案
这些表的结构都是完全一样的。
select * from
(select * from A
union all
select * from B
union all
select * from C
union all
select * from D
union all
select * from E) tb where td.name='abc'