Hi Lorne,

>You have no functions in your select that use a group by.
>If you just use the ORDER BY, you are on the right track.
>If you really MUST have a group by, you will need to do something like:
>SELECT a.1, a.2,a.3,COUNT(a.3)
>FROM atable a
>order by a.1
>group by a.1;
>
>By having an aggerate function in the select, it can then group. In Oracle GROUP resets an aggerate funtion.

My query is now as follows:

Select training.idtraining,training.course,training.subject,training.held,training.course_date from training order by training.course group by training.course

However, Oracle gives me the error:

SQL command not properly ended

Any ideas ? I've cut and pasted the above SQL statement, so this is definitely what I'm sending to Oracle.

Best.

Matt.