A quote from Experts Exchange...I let you judge for yourself...

<<
Just to clarify, the fact that I have duplicates isn't a problem --
the problem arises when I'm trying to SUM the value of one of the
fields in tblSuite. I just need to know how to ignore those
duplicates, not to get rid of them.
>>

"Cimode" <cimode (AT) hotmail (DOT) com> wrote

I'll laugh, thanks.

"Cimode" <cimode (AT) hotmail (DOT) com> wrote

I would be tempted to offer something like the following in ExpertsExchange:

select sum (TheColumn) as Total
from (select distinct * from TheTable);

But I would be afraid that somebody would not realize that I'm just goofing.