07-31-2018, 06:16 AM
That's some profound digging around you did there.. I'm trying to think about a use case where a query would fail if that DISTINCT wouldn't be there. Can't think of anything, but then again I'm no SQL wizard. Maybe it would be good to run a test, by removing it and opening/exporting all kinds of different reports to see if one breaks.