select * from ta union select * from tb union select * from tc union select * from td order by d_time
要前10条? select top 10 * from ( select * from ta union select * from tb union select * from tc union select * from td order by d_time)
create view tview as select c1,c2,d_time from ta union all select c1,c2,d_time from tb union all select c1,c2,d_time from tc union all select c1,c2,d_time from td union all select c1,c2,d_time from te;create view tsortview as select * from tview order by d_time;select * from tview where rownum<=10;
thanks!!
union
select * from tb
union
select * from tc
union
select * from td
order by d_time
select top 10 * from (
select * from ta
union
select * from tb
union
select * from tc
union
select * from td
order by d_time)
select c1,c2,d_time from ta
union all
select c1,c2,d_time from tb
union all
select c1,c2,d_time from tc
union all
select c1,c2,d_time from td
union all
select c1,c2,d_time from te;create view tsortview as
select * from tview order by d_time;select * from tview where rownum<=10;
select * from tb union all
select * from tc union all
select * from td
order by d_time)