要查询最后注册的100个用户的详细信息,其中用户的详细信息在baseinfo,用户注册时间在userinfo,有没有办法用嵌套查询出来。我写了
select * from baseinfo where userid in
(select top 100 userid from userinfo order by regdate desc)是错的。查出来是按照详细信息baseinfo排序
select * from baseinfo where userid in
(select top 100 userid from userinfo order by regdate desc)是错的。查出来是按照详细信息baseinfo排序
order by b.regdate
order by b.regdate desc
order by b.regdate desc
(select top 100 userid from userinfo order by regdate desc)
设主外键了没有