将2张表的查询结果进行分页

[ld191474639]

select top 2 * from (select * from actor,movie where actor.aid=movie.mid) c where c.id not in(select top 2 id from c) 

报对象名c无效，请问正确的sql语句该怎么写呢

[陈绍唐我爱你]

select top 2 * from (select * from actor,movie where actor.aid=movie.mid )T1 
where id not in
     (select top 2 id 
      from 
      (select * from actor,movie where actor.aid=movie.mid )T2
      )