sorting and keeping unique / primary ids together is usually a good bet when trying to suppress duplicate data.
Suppressing has NO impact on calculations (sum, count, max, min, etc.).
Be careful with select statements as it is easy to change outer joins into inner joins based on the select condition(s).
Edited by DBlank - 17 Aug 2011 at 7:55am