Re: Dupe count on complex query

[Phillip Ward]

"Select Distinct" is [almost] always a Red Flag for me, especially where multiple Joins are involved. The "need" for it almost always indicates incorrect join conditions or data structure that are not correctly normalised.
"Distinct" and "Group By" is definitely a No-No.

Without seeing your table structures and sample data, all I can suggest is breaking the query down and reconstructing it, adding back one table at a time until the "duplication" appears, then correct that.

Regards, Phill W.