A DISTINCT seems to work on the whole row of results. Can it be limited to one field?
SELECT DISTINCT Email, count( tblusers.iID ) AS cnt, tblusers.iID, sFirstName, sLastName WHERE tblusers.iID = tbluseranswers.iUserID AND tbluseranswers.bCorrect = \'1\' GROUP BY tblusers.iID having cnt=4 ORDER BY tblusers.iID ASC
This will result in several rows with the same Email address. But i want only one result for all rows with the same Email address...
Does anyone have an idea?
SELECT DISTINCT problem
1 reply to this topic
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users