Do we always get a distinct in our query against non aggregated columns? Is there a way to not have it
I created a query with just country in it. It had a "select disticnt country....."
There is a property on the query called 'Auto Group and Sum'. It is set to yes by default. When this is set to yes, a query of one data item that has aggregation property set to none, will do a distinct. Turn the property off, and you will not get a distinct.