markw

Hello, A DISTINCT seems to work on the whole row of results. Can it be limited to one field? For example: 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? Thanks, Mark.