[sabret00the]

thanks dean that worked out perfectly.

here's the code incase anyones interested

[sql] SELECT grps.groupid, grps.title, grps.description, grps.catid, grps_catergories.title AS catname, grps.approved, grps.leaderid
FROM grps_catergories
INNER JOIN grps ON grps_catergories.catid = grps.catid AND grps.approved = 1
INNER JOIN grps AS G2 ON grps_catergories.catid = G2.catid AND G2.approved = 1 AND grps.title >= G2.title
GROUP BY grps_catergories.title, grps.title, grps.description, grps.leaderid
HAVING COUNT(*) <= 10
ORDER BY grps.title
[/sql]