>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.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.