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.
OK, my query is now:
Select course,subject,held,course_date,idtraining,count(training.course)
from training order by training.course group by training.course
This gives me the error:
"SQL command not properly ended"
Again, this modified query gives the desired result in VFP.
Any idea where I'm going wrong ?
Best.
Matt.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only