Select DISTINCT not very useful...

[Michael Geary]

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?

-michael

On Friday, October 24, 2003, at 02:22 PM, Ruslan Zasukhin wrote:

>> My results (in V4MD) are like this:
>>
>> [#StructureNumber: 2970, #StructureName: "Gastrocnemius"],
>> [#StructureNumber: 2970, #StructureName: "Gastrocnemius"],
>> [#StructureNumber: 2970, #StructureName: "Gastrocnemius"],
>> [#StructureNumber: 2970, #StructureName: "Gastrocnemius"],
>> [#StructureNumber: 2970, #StructureName: "Gastrocnemius"],
>> [#StructureNumber: 2970, #StructureName: "Gastrocnemius"],
>> [#StructureNumber: 92, #StructureName: "femur"],
>> [#StructureNumber: 92, #StructureName: "femur"],
>> [#StructureNumber: 92, #StructureName: "femur"],
>> [#StructureNumber: 92, #StructureName: "femur"],
>> [#StructureNumber: 92, #StructureName: "femur"],
>> [#StructureNumber: 92, #StructureName: "femur"],
>> [#StructureNumber: 92, #StructureName: "femur"],
>> [#StructureNumber: 92, #StructureName: "femur"],
>>
>> This ought to be two hits, not several.
>
> So what problems?
> Aha, you select from 2 tables...
>
> Try add DISTINCT after FROM keyword
>
> FROM DISTINCT
> ImageMap,
> structure
>
> -- 
> Best regards,
> Ruslan Zasukhin      [ I feel the need...the need for speed ]