>>Hi,
>>
>>How can i exclude duplicate records from a table using select sql statements?
>>
>>I can't understand why my select distinct statement does not works. The result sets still includes duplicate records.
>>
>>Any other way to strip off duplicate records?
>>
>>TIA.
>
>This is not possible.
>Keep in mind that DISTINCT works for ALL fields, I mean that ALL fields must be equal if you want the record to be excluded.
Thanks Borislav, now I remember. Do you have any idea how can I strip duplicate records? I previously see posting about duplicates here.