Fixed my original problem, but created another in the process. If I want to create a query where a field must be distinct but is not displayed, how would I do this?
SELECT DISTINT(field1) does want I want, but displays field1 (which I do not want).
GROUP BY field1
