如表A
ID content time
1 Asdfsd 2006-04-10 12:38:00
2 Asdfsd 2006-04-10 12:38:00
3 Asdfsd 2006-04-10 12:38:00
4 Asdfsd 2006-04-9 12:38:00
5 Asdfsd 2006-04-9 12:38:00
6 Asdfsd 2006-04-8 12:38:00
7 Asdfsd 2006-04-8 12:38:00
表B
ID content time
1 Bsdfsd 2006-04-10 12:38:00
2 Bsdfsd 2006-04-10 12:38:00
3 Bsdfsd 2006-04-10 12:38:00
4 Bsdfsd 2006-04-10 12:38:00
5 Bsdfsd 2006-04-10 12:38:00
6 Bsdfsd 2006-04-10 12:38:00
7 Bsdfsd 2006-04-10 12:38:00
8 Bsdfsd 2006-04-9 12:38:00
9 Bsdfsd 2006-04-9 12:38:00
10 Bsdfsd 2006-04-8 12:38:00
11 Bsdfsd 2006-04-8 12:38:00查询出来的结果
ID content time
1 Asdfsd 2006-04-10 12:38:00
2 Asdfsd 2006-04-10 12:38:00
3 Asdfsd 2006-04-10 12:38:00
4 Bsdfsd 2006-04-10 12:38:00
5 Bsdfsd 2006-04-10 12:38:00
6 Bsdfsd 2006-04-10 12:38:00
7 Bsdfsd 2006-04-10 12:38:00
8 Bsdfsd 2006-04-10 12:38:00
9 Bsdfsd 2006-04-10 12:38:00
10 Bsdfsd 2006-04-10 12:38:00谢谢..............
ID content time
1 Asdfsd 2006-04-10 12:38:00
2 Asdfsd 2006-04-10 12:38:00
3 Asdfsd 2006-04-10 12:38:00
4 Asdfsd 2006-04-9 12:38:00
5 Asdfsd 2006-04-9 12:38:00
6 Asdfsd 2006-04-8 12:38:00
7 Asdfsd 2006-04-8 12:38:00
表B
ID content time
1 Bsdfsd 2006-04-10 12:38:00
2 Bsdfsd 2006-04-10 12:38:00
3 Bsdfsd 2006-04-10 12:38:00
4 Bsdfsd 2006-04-10 12:38:00
5 Bsdfsd 2006-04-10 12:38:00
6 Bsdfsd 2006-04-10 12:38:00
7 Bsdfsd 2006-04-10 12:38:00
8 Bsdfsd 2006-04-9 12:38:00
9 Bsdfsd 2006-04-9 12:38:00
10 Bsdfsd 2006-04-8 12:38:00
11 Bsdfsd 2006-04-8 12:38:00查询出来的结果
ID content time
1 Asdfsd 2006-04-10 12:38:00
2 Asdfsd 2006-04-10 12:38:00
3 Asdfsd 2006-04-10 12:38:00
4 Bsdfsd 2006-04-10 12:38:00
5 Bsdfsd 2006-04-10 12:38:00
6 Bsdfsd 2006-04-10 12:38:00
7 Bsdfsd 2006-04-10 12:38:00
8 Bsdfsd 2006-04-10 12:38:00
9 Bsdfsd 2006-04-10 12:38:00
10 Bsdfsd 2006-04-10 12:38:00谢谢..............
from
(select * from tableb union all
select * from tableb) a
from
(select * from tablea union all
select * from tableb) a
insert into @t select 1,'Asdfsd','2006-04-10 12:38:00'
union all select 2,'Asdfsd','2006-04-10 12:38:00'
union all select 3,'Asdfsd','2006-04-10 12:38:00'
union all select 4,'Asdfsd','2006-04-9 12:38:00'
union all select 5,'Asdfsd','2006-04-9 12:38:00'
union all select 6,'Asdfsd','2006-04-8 12:38:00'
union all select 7,'Asdfsd','2006-04-8 12:38:00'declare @a table([ID] int,content varchar(10),[time] datetime)
insert into @a select 1,'Bsdfsd','2006-04-10 12:38:00'
union all select 2,'Bsdfsd','2006-04-10 12:38:00'
union all select 3,'Bsdfsd','2006-04-10 12:38:00'
union all select 4,'Bsdfsd','2006-04-10 12:38:00'
union all select 5,'Bsdfsd','2006-04-10 12:38:00'
union all select 6,'Bsdfsd','2006-04-10 12:38:00'
union all select 7,'Bsdfsd','2006-04-10 12:38:00'
union all select 8,'Bsdfsd','2006-04-9 12:38:00'
union all select 9,'Bsdfsd','2006-04-9 12:38:00'
union all select 10,'Bsdfsd','2006-04-8 12:38:00'
union all select 11,'Bsdfsd','2006-04-8 12:38:00'select [id]=identity(int,1,1),b.content,b.[time] into # from (select top 10 a.* from
(
select * from @t
union all
select * from @a
)a
order by a.[time] desc) b order by contentselect * from #drop table #