"John D. Burger" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
