Hi,

I'm trying to consruct a query which I can send to VFP, Oracle or SQL Server and get the same result. The query, which works fine with VFP, is as follows:

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

i.e. I want a resulting cursor with these fields, where the course field contains unique values.

For Oracle, I get the error:

Not a GROUP By expression

In SQL Server, I get the error:

Column 'training.idtraining' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.

The table structures are the same for all three.

How do I get the result set I want from Oracle and SQL Server ?

Best.

Matt.