sql = select a.*,b.* from user_information a left outer join zhaopian b on a.user_netname=b.user_netname where user_sex="男"这条 显示两张表里人的全部信息 我想显示 按ID 倒序排列 选择头四条记录, 这个top 加在什么地方 ? 我加在 select a.top *,b.top * from 报错 高手看看加在哪
调试欢乐多
order by 表别名.user_id desc
select top 4 a.*,b.*
from user_information a
left outer join zhaopian b
on a.user_netname=b.user_netname
where 表别名.user_sex="男"
order by 表别名.user_id desc
from user_information a left outer join zhaopian b on a.user_netname=b.user_netname
where user_sex='男'
order by a.id desc --a.id自己替换吧
把得到的结果再取top4
sql = SELECT TOP 4 * FROM (select a.*,b.* from user_information a left outer join zhaopian b on a.user_netname=b.user_netname where user_sex="男")