Hi Mark,

>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?

Yes, but I've received conflicting replies from the VFP forum and this forum.

When I execute:

Select course,subject,held,course_date,idtraining from training group by course,subject,held,course_date,idtraining;

all of the records are returned from Oracle, VFP or SQL Server.

I'm confused, because in my opinion this makes GROUP BY redundant in Oracle, as you are saying that all of the fields MUST be included in the GROUP BY clause.

To illustrate my problem, my sample data is as follows:

Course  Subject  Held       Course_Date  IdTraining
Matt1   Test1    01/02/2000 01/02/2000   2
Matt2   Test2    15/02/2000 17/02/2000   3
Matt1   Test1    01/02/2000 01/02/2000   4 

There are other fields in the table, but these are the ones I will be displaying to the user.

When I execute my query, I want to return the following:

Course  Subject  Held       Course_Date  IdTraining
Matt1   Test1    01/02/2000 01/02/2000   4 
Matt2   Test2    15/02/2000 17/02/2000   3

I can do this easily in SQL Server or VFP, simply by grouping on Course.

Are we really saying that it is impossible to get this result from an Oracle back-end ?

Best.

Matt.