In oql-ojb.g, I find the following comment: // "distinct" is effectively ignored as we ALWAYS select distinct
and indeed, the "distinct" token is ignored by the parser. But I never see "DISTINCT" in my spy.log; nor do I see any other reference to distinct anywhere in ...ojb.odmg, so I'm not sure where the "ALWAYS select distinct" happens. Is it possible to force an ODMG query to do SELECT DISTINCT? thanks, -steve Steve Clark Technology Applications Team Natural Resources Research Center/USGS [EMAIL PROTECTED] (970)226-9291 --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]