数据库“列合并排序”语句

select  * from(select a as v from table1 where " 条件"

       union all

       select b as v from table2 where "条件")

       order by v

posted @ 2015-01-13 12:58  Y-Y-J  阅读(175)  评论(0)    收藏  举报