declare @prod table (pid int, title varchar(30)) insert into @prod select 1,'测试产品1' union all select 2,'测试产品2' union all select 3,'测试产品3' union all select 4,'测试产品4' union all select 5,'测试产品5' declare @paixu table (pid int, seq int) insert into @paixu select 4,1 union all select 3,2 --(select title from @paixu as a join @prod as b on a.pid=b.pid) order by a.seq asc --union all --(select title from @prod where title not in (select b.title from @paixu as a join @prod as b on a.pid=b.pid ) )order by pid asc select * from( select top 100 percent title from @paixu as a join @prod as b on a.pid=b.pid order by a.seq asc ) k union all select * from ( select top 100 percent title from @prod where title not in (select b.title from @paixu as a join @prod as b on a.pid=b.pid ) order by pid asc) p