Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

sqlserver inner join查询无法使用Pager分页 #227

Closed
MrDingz opened this issue May 17, 2012 · 3 comments
Closed

sqlserver inner join查询无法使用Pager分页 #227

MrDingz opened this issue May 17, 2012 · 3 comments
Labels
FAQ

Comments

@MrDingz
Copy link

MrDingz commented May 17, 2012

有SQL语句：
select
table1.*
from
table1
inner join
table2
on
table1.id=table2.id
查询语句中很很多重复结果，如果加上Pager查询的结果是不正确的.
去掉重复结果的Distinct在Nutz包装后是不能执行的：
select distinct
table1.*
from
table1
inner join
table2
on
table1.id=table2.id ------ 关键字‘distinct’附近有语法错误
@MrDingz
Copy link
Author

MrDingz commented May 17, 2012

如此要是想分页只能自己手动写了，那个pager成了摆设

@wendal
Copy link
Member

wendal commented May 17, 2012

Nutz生成的语句是怎样的? 贴一下看看?

@wendal
Copy link
Member

wendal commented Jul 6, 2012

太复杂的SQL, 还是不要用内置分页了

@wendal wendal closed this as completed Jul 7, 2012
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
FAQ
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@wendal @MrDingz