你可以将你得到的结果集再当作一个表:
select * from(
SELECT title,province FROM T_Ad_Deputize
UNION
SELECT Title, province FROM T_Ad_CatenationJoin ) as a
你可以使用top n来分页,找一个主键,假设title是主键。
select top n * from (SELECT title,province FROM T_Ad_Deputize
UNION
SELECT Title, province FROM T_Ad_CatenationJoin ) as a
where title not in(
select top (N-1)*X title from (SELECT title,province FROM T_Ad_Deputize
UNION
SELECT Title, province FROM T_Ad_CatenationJoin ) as a
)
其中X为你每页的条数,n为你当前希望得到的页