I have the table 'tutors' with PK tCode. I also have table 'groups' with FK 'tCode'. Is it possible, using 1 query, to pull up all tutors with at least 2 groups?

I do this right now putting all group's tCodes in a big array. Im sure this isnt the best way.

Thanks for any feedback.

  SELECT t.*,COUNT(*) AS num FROM groups g, tutors t WHERE t.tCode=g.tCode GROUP BY t.tCode HAVING num>2;

cheers

np - the HAVING clause is one that isn't often used but it's perfect for this.