"John D. Burger" <john@mitre.org> writes:
> I don't know what that does. If you mean:
>
> select max(p2.personID), p2.eyeColor, p2.hairColor, p2.skinColor
> from persons as p2
> group by p2.personID, p2.eyeColor, p2.hairColor, p2.skinColor
> having count(*) = 1;
>
> then I don't think that works either - if I include personID in the GROUP BY,
select max(personid) as personid, eyecolor, haircolor, skincolor
from persons
group by eyecolor, haircolor, skincolor
having count(*) = 1
--
greg