SQLSERVER取前10条记录怎样取

Question

单表我会
select top 10 from table order by id 
联表呢?
例如
select top 10 from (select A.name,B.sex from userinfo A,sexinfo B where A.id = B.id and A.sex = B.sexid) order by id
就会报错,请指教