Microsoft KB Archive/70824

PRSQL9103004: Results Incorrect with GROUP BY and Sum in Views ID Number: Q70824

1.10 OS/2 buglist1.10

Summary:

PROBLEM ID: PRSQL9103004

SYMPTOMS A view created with a GROUP BY clause and an aggregate expression produces incorrect cardinality in the result set.

RESOLUTION Instead of creating a view, use a temporary table or the original table.