Hi Mark,

>The way you want it, you can not do in Oracle because the IdTraining values are unique. How do you know what IDTraining value is correct, 2 or 4? Liek I said before, Oracle is very strict on aggregating fields and group by clauses. Looking at what you are trying to do logically, Oracle is correct.

I think the reason I'm feeling so frustrated over this is that I was naive enough to believe that SQL was a standard. Most of the problems we seem to come up against involve Oracle.

>Now a possible work-around. Create a VFP remote view of the table that selects all the records. Run a local select against this view. Since the VFP syntax is much looser, this should work.

Thanks. I don't know why I didn't think of this. We're using SPT, but the same idea obviously works.

Cheers.

Matt.