-
- 160 Posts
I have a fairly complex query and I'm trying to get a count before I display the data on the page so I can limit the data. However, when I use any of the joins or a groupby, the count returns odd numbers that are not correct. For example, if I only use one of the joins in the query, I get a count of 0, but if I remove the join and add the groupby, I get a count of 1. In both instance there are far more than one result. In case you are wondering, a join and a groupby together returns a result of 0.
The question is, why is this happening and is there a way around it?
-
- 5,888 Posts