分别查询:
select count(*) from tmp.tmp_shi_pair_sheng2;--44687
select count(*) from tmp.tmp_not_handle_is_finished;--7378033
select count(*) from tmp.tmp_area_same_other --99871
union all
1.当两者数量相差不是很大时,顺序是正常的
select count(*) from tmp.tmp_area_same_other
union all select count(*) from tmp.tmp_zhi_xia_shi_suo_zai_qu_pair_zhi_xia_shi2;
2.当两者数量相差大时,顺序是变了
select count(*) from tmp.tmp_shi_pair_sheng2
union all select count(*) from tmp.tmp_not_handle_is_finished;