2016 SQL Edit bug: If there is a Where and no group by, can not edit without Error 1001
Can not make any change to the SQL (even adding a space and taking it out) for any SQL with a WHERE clause but no GROUP BY. For example, to put a DISTINCT after the SELECT.
Thanks for reporting.
We will add this bug report to our backlog and see that it is prioritized and handled.
In the meantime, I’m updating the status for ‘No Current Plan’ so that you use your votes again.