Hi All,
Does PHPRunner support SELECT DISTINCT?
I read the manual, as here: http://xlinesoft.com/phprunner/docs/query_designer.htm (at the bottom of this page), DISTINCT keyword is not supported.
But, I tried PHPRunner 7.1 B21342x86, by following SQL statement, and it works:
SELECT
DISTINCT(table1.field2),
table1.ID,
table1.field1,
table1.field3,
table1.field4,
COUNT(CASE WHEN table2.field9='1' THEN 1 END) AS F9A,
COUNT(CASE WHEN table2.field9='2' THEN 1 END) AS F9B,
COUNT(CASE WHEN table2.field9='3' THEN 1 END) AS F9C
FROM table1
INNER JOIN table2 ON table1.field1 = table2.field1
GROUP BY table1.field2
ORDER By table1.field2
Question now ... Does PHPRunner support SELECT DISTINCT?