Select DISTINCT not very useful...

[Ruslan Zasukhin]

on 10/24/03 23:35, Michael Geary at listmail at gearyweb.com wrote:

> Hi Ruslan,
> 
> nope this doesn't work. I suspect it's because your DISTINCT is only
> affecting _literal_ matches, where the record ID is the same. if my
> query were to select an additional column, the hits would all be
> different, because that third column would be unique. What I want is to
> be able to filter out duplicate _results_, regardless of the number of
> unique pointer IDs involved.
> 
> Does that make sense?

I don't know.

Send me please small db and query you try to do.

And what you expect to get

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------