>>ORDER BY must be the last clause
>
>That gives me the following:
>
>Result: Not a group by expression
>
>Query: Select course,subject,held,course_date,idtraining,count(training.course) from training group by training.course order by training.course
>
>This is the same situation I was in previously. ;-(
In Oracle, you have to GROUP BY
every column that is not selected as an aggregate. In your example above you have to GROUP BY all 5 of the first columns.
Did you see my reply to this in the VFP forum?
Mark McCasland
Midlothian, TX USA