|
1.6. If a GROUP BY phrase exists, a SELECT phrase cannot include columns which are not included in the GROUP BY expression, or are not aggregated using the AVG,MIN,MAX,SUM,COUNT functions.
Also, when GROUP BY is specified, either each column in any non-aggregate expression in the SELECT list should be included in the GROUP BY list, or the GROUP BY expression must exactly match the SELECT list expression.
If a GROUP BY phrase is defined in a query then our utility will apply a MAX() function to each column which not in GROUP BY clause and not aggregated.
Note: You should correct logical fields
themselves (include into GROUP BY clause or replace with constant @True as ... or @False as ... (m.True=.T. and m.False= .F.)) because a MAX() function can not be used with a bit data type.
back
to features list
|
