...> list the fields in the group by based on the selected fields...to list every field in the Select clause, except aggregates, in the Group By clause. -- Cindy Winegarden cindy@cindywinegarden.com...it gives me an error GROUP By clause missing or invalid. Anything im...>>>> FROM staffdtl ; WHERE staffid = "XXX" ; GROUP BY CRANGGRPID ; ORDER BY dDateStart, ...

... I list the fields in the group by based on the selected fields.... to list every field in the Select clause, except aggregates, in the Group By clause. -- Cindy Winegarden cindy@cindywinegarden.com ... it gives me an error GROUP By clause missing or invalid. Anything im...>>> FROM staffdtl ; WHERE staffid = "XXX" ; GROUP BY CRANGGRPID ; ORDER BY dDateStart, ...

... best to list every field in the Select clause, except aggregates, in the Group By clause. -- Cindy Winegarden cindy@cindywinegarden.com VFP ...execute it, but in version 9 it gives me an error GROUP By clause missing or invalid. Anything im ... ; FROM staffdtl ; WHERE staffid = "XXX" ; GROUP BY CRANGGRPID ; ORDER BY dDateStart, dDateEnd,...

...7 when i try to execute it, but in version 9 it gives me an error GROUP By clause missing or invalid. Anything im missing here? SELECT MIN(workdate) as DStart, MAX(workdate) as...> cdsc,CRANGGRPID as rangegroupid ; FROM staffdtl ; WHERE staffid = "XXX" ; GROUP BY CRANGGRPID ; ORDER BY dDateStart, dDateEnd, itimeStart, itimeEnd ; ...

... when i try to execute it, but in version 9 it gives me an error GROUP By clause missing or invalid. Anything im missing here? SELECT MIN(workdate) as DStart, MAX(workdate) ...cawaydsc as cdsc,CRANGGRPID as rangegroupid ; FROM staffdtl ; WHERE staffid = "XXX" ; GROUP BY CRANGGRPID ; ORDER BY dDateStart, dDateEnd, itimeStart, itimeEnd ; INTO...

...ok t/NamedObjectSet................ok t/SQL-limit-clause..............ok t/SQL-order-by-clause...........ok t/SQL-where-clause..............ok t/SQL...........................ok t/SQL/Delete-bind-params.../Select-bind-params........ok t/SQL/Select-from-clause........ok t/SQL/Select-group-by-clause....ok t/SQL/Select-having-clause......ok t/SQL/Select-select-clause......ok t...

...ok t/NamedObjectSet................ok t/SQL-limit-clause..............ok t/SQL-order-by-clause...........ok t/SQL-where-clause..............ok t/SQL...........................ok t/SQL/Delete-bind-params.../Select-bind-params........ok t/SQL/Select-from-clause........ok t/SQL/Select-group-by-clause....ok t/SQL/Select-having-clause......ok t/SQL/Select-select-clause......ok t...

...ok t/NamedObjectSet................ok t/SQL-limit-clause..............ok t/SQL-order-by-clause...........ok t/SQL-where-clause..............ok t/SQL...........................ok t/SQL/Delete-bind-params.../Select-bind-params........ok t/SQL/Select-from-clause........ok t/SQL/Select-group-by-clause....ok t/SQL/Select-having-clause......ok t/SQL/Select-select-clause......ok t...

...ok t/NamedObjectSet................ok t/SQL-limit-clause..............ok t/SQL-order-by-clause...........ok t/SQL-where-clause..............ok t/SQL...........................ok t/SQL/Delete-bind-params.../Select-bind-params........ok t/SQL/Select-from-clause........ok t/SQL/Select-group-by-clause....ok t/SQL/Select-having-clause......ok t/SQL/Select-select-clause......ok t...

...ok t/NamedObjectSet..................ok t/SQL-limit-clause................ok t/SQL-order-by-clause.............ok t/SQL-where-clause................ok t/SQL.............................ok t/SQL/Delete-bind...Select-bind-params..........ok t/SQL/Select-from-clause..........ok t/SQL/Select-group-by-clause......ok t/SQL/Select-having-clause........ok t/SQL/Select-select-clause...........