Books online isn't giving me sufficient information. I'm having a difficult time finding something on google as well.
If I want to add the DISTINCT clause but I don't want results showing up on that field, is that even possible? I'm taking a guess that DISTINCT has to be used after SELECT and can't be used in the WHERE part of the script....if so, it's probably different syntax....?
T.I.A.
JM