Hi,

I have a problem with the following query:

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

I'm trying to select records from the training table, with one record for each unique value of the training.course field.

The above query works in SQL Server and VFP, but Oracle doesn't like it because:

"each column in the select, which is not an
aggregate function, must be included in the GROUP BY clause"

I can't use SELECT DISTINCT, because training.idtraining is unique for each record and this causes all records to be returned.

How do I get the result I want from Oracle ?

Best.

Matt.