P
Paulie P
Hello,
I'm a simple group by query against a view to get subtotals but I'm getting
some odd results.
When I run the query directly against the view, the subtotals add up to 205
records even though the view returns 207 records. When I put the view's
results into a table using SELECT * INTO and then rerun the query. the
subtotals add up to 207 as expected. Does anyone know why I'm getting
different results?
Regards
Paulie
I'm a simple group by query against a view to get subtotals but I'm getting
some odd results.
When I run the query directly against the view, the subtotals add up to 205
records even though the view returns 207 records. When I put the view's
results into a table using SELECT * INTO and then rerun the query. the
subtotals add up to 207 as expected. Does anyone know why I'm getting
different results?
Regards
Paulie