有时项目需要查询多张同结构表。那么我们不需要每张表分开查询,首先将多张表
融合为一个整体,随后进行统一查询
select * from (
select sx,sxm,sbls,zftzj from EX_01 union all
select sx,sxm,sbls,zftzj from EX_02 union all
select sx,sxm,sbls,zftzj from EX_03 union all
select sx,sxm,sbls,zftzj from EX_04 union all
select sx,sxm,sbls,zftzj from EX_05 union all
select sx,sxm,sbls,zftzj from EX_06 union all
select sx,sxm,sbls,zftzj from EX_07
) a
随后我们可以将a表看成一个独立的表,进行查询
融合为一个整体,随后进行统一查询
select * from (
select sx,sxm,sbls,zftzj from EX_01 union all
select sx,sxm,sbls,zftzj from EX_02 union all
select sx,sxm,sbls,zftzj from EX_03 union all
select sx,sxm,sbls,zftzj from EX_04 union all
select sx,sxm,sbls,zftzj from EX_05 union all
select sx,sxm,sbls,zftzj from EX_06 union all
select sx,sxm,sbls,zftzj from EX_07
) a
随后我们可以将a表看成一个独立的表,进行查询