[Quote=引用 10 楼 investruth 的回复:]
引用 9 楼 danni_tom 的回复:
select * from (
select top 5 protId,sortId,userId,regdate,'新表' tbname from tb1 order by regdate desc
union
select top 5 protId,sortId,userId,regdate,'旧表' tbname from tb2 orde……
[/Quote]
[Quote=引用 9 楼 danni_tom 的回复:]
select * from (
select top 5 protId,sortId,userId,regdate,'新表' tbname from tb1 order by regdate desc
union
select top 5 protId,sortId,userId,regdate,'旧表' tbname from tb2 order by regdate desc
)as……
[/Quote]
select top(10) * from (select * from tb1 union all select * from tb2 ) as b order by ttime desc
首先将两个表数据合并 然后再去前10条就可以了
select * from (
select top 5 protId,sortId,userId,regdate,'新表' tbname from tb1 order by regdate desc
union
select top 5 protId,sortId,userId,regdate,'旧表' tbname from tb2 order by regdate desc
)as a
order by a.regdate desc