Hi Lorne,

Please ignore that last message - I've missed out the count()
>
>>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.