Wrong Totla count

QuestionsWrong Totla count
Srinivas asked 10 years ago

My query is like:
select * from(
(select * from a where condition)
union
(select * from b where condition)
union
(select * from c where condition)
.
.
.
union
(select * from z where condition)
) as o.
Assume there are 5 records from the out come of above query, it is displaying 5 records correctly, but the total count at list1_pager_right is more than 5.

help me solve the problem

1 Answers
Abu Ghufran answered 10 years ago

Well, i cannot say exactly unless you send exact mysql dump and sql statement to regenerate case. You can email me at [email protected].

One quick tip, avoid using 'o' as alias, and it may be internally used by grid too.

Your Answer

12 + 14 =

Login with your Social Id:

OR, enter

Attach code here and paste link in question.
Attach screenshot here and paste link in question.



How useful was this discussion?

Click on a star to rate it!

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate it.

We are sorry that this post was not useful for you!

Let us improve this post!

Tell us how we can improve this post?