Sethington
Technical User
I have an app at work that will only allow me to customize the WHERE clause on a SQL statement.
Currently the SQL Statement is hard coded something like this:
SELECT * FROM `ERRORS`
Is there a way to do a DISTINCT in the WHERE clause that would return the same results as:
SELECT DISTINCT `MEMBER_NUMBER` FROM `ERRORS`
Currently the SQL Statement is hard coded something like this:
SELECT * FROM `ERRORS`
Is there a way to do a DISTINCT in the WHERE clause that would return the same results as:
SELECT DISTINCT `MEMBER_NUMBER` FROM `ERRORS`