使用sqlserver查询两表,并实现分页,代码如下
select top 7 users.*,users.u_id as usersid,
users.*,company.u_id as companyid ,company.*
from t_users users,t_company company
where users.u_id=company.u_id
order by users.u_id desc
这样是正确的
select top 5 allinfo.* from
(
select top 7 users.*,users.u_id as usersid,
users.*,company.u_id as companyid ,company.*
from t_users users,t_company company
where users.u_id=company.u_id
order by users.u_id desc
)
allinfo
使用下面的语句后,提示allinfo 多次引用 u_id 网前辈给看一下,sqlserver的语句
[解决办法]
select top 5 allinfo.* from
(
select top 7 users.*,users.u_id as users_u_id ,
users.*,company.u_id as company_u_id ,company.*
from t_users users,t_company company
where users.u_id=company.u_id
order by users.u_id desc
)
allinfo
[解决办法]
users.*,company.* 都含有u_id ，在allinfo中重复了
一一列出两表的字段,重复的字段改名应该可以
