Wednesday, 7. September 2005 05:02.
Firebird doesn't want an SQL statement «SELECT COUNT(*), id, name_en FROM Languages;». It says «Invalid expression in the select list (not contained in either an aggregate function or the GROUP BY clause).»Peter explains why: «If you combine in the select an aggregate function (count, sum, max) together with 'normal' colums (id, name, etc.), all the normal columns have to be in the group by clause.» (forums.devshed.com/archive/t-180673/Help-with-query-Invalid-expression-in-the-select-list)