有2个表
TABLE_A,(c1,c2,date)
TABLE_B,(c3,c4,date)
想达到的效果:按照时间排序。如:
c1 c2 2009-02-19
c3 c4 2009-02-18
c1 c2 2009-02-17
c1 c2 2009-02-16
TABLE_A,(c1,c2,date)
TABLE_B,(c3,c4,date)
想达到的效果:按照时间排序。如:
c1 c2 2009-02-19
c3 c4 2009-02-18
c1 c2 2009-02-17
c1 c2 2009-02-16
可以先建个视图然后再从视图的时候使用order by 排列一下
(select c1,c2,date from tableA union all
select c3,c4,date from tableB)
order by date
这样应该可以的吧。你可以试试
UNION
SELECT C3 AS A1,C4 AS A2,C_DATE FROM A_2
ORDER BY C_DATE DESC