V4RB2 Group by weirdnes

[erne]

Hello Ruslan,

GROUP BY Sql clause does not recognize aggregate functions in Select

try this Sql Select:
SELECT region, sum(sales) as 'total' FROM offices group by region
and you'll get vError 271624 (In the SELECT clause you can use only 
fields listed in the GROUP BY and aggregative functions).

Mantis report id 595


Cool Runnings,
Erne.

|er| musical box
|ne| a media store