grouping by for a query

[sabret00the]

is their a method at all to get it only select XX records from each group?

this is the query

                SELECT grps.groupid, grps.title, grps.description, grps.catid, grps_catergories.title AS catname, grps.approved, grps.leaderid 
                  FROM grps 
                 LEFT JOIN grps_catergories ON (grps_catergories.catid = grps.catid) 
                  WHERE grps.approved=1 
                   GROUP BY grps_catergories.catid
                  ORDER BY grps.title 

and i'd like to select a maximum of 10 records from each catid

and example of the catid table would be

 a table (catergories)
   catid   	  title   	  description
   1 	Automotive 	For groups referring to cars, bikes or such
   2 	Computers 	For groups referring to computers, whether hardwar...
   3 	Education 	For groups regarding learning, whether it be help ...
   4 	Entertainment 	For groups surrounding anything entertaining, visu...
   5 	Games 	For groups surrounding games you love, digital or ...
   6 	Health & Fitness 	For groups pertaining to well-being
   7 	Home & Families 	For groups regarding the home life
   8 	Lifestyles 	For groups surrounding lifestyles whether it be go...
   9 	Places & Travel 	For groups referring to towns, cities and holidays
   10 	Religion & Belief 	For groups surrounding christianity, islam, buddis...
 11 	Sports & Recreation 	For groups referring to sports, whether it be Foot...
   12 	Others 	For everything else

these are leftjoined to a groups table so it will display all groups that fall into each catergory, however i went to make it so it shows a maximum of ten records for each catid

i'm wondering if this is possible via MySQL?

[coiL]

If I understand correctly what you are asking, you need to use LIMIT

SELECT grps.groupid, grps.title, grps.description, grps.catid, grps_catergories.title AS catname, grps.approved, grps.leaderid 
                  FROM grps 
                LEFT JOIN grps_catergories ON (grps_catergories.catid = grps.catid) 
                  WHERE grps.approved=1 
                   GROUP BY grps_catergories.catid
                  ORDER BY grps.title 
                   LIMIT 10 

[sabret00the]

limit would limit it to ten records in total where as i want to limit it to ten records per grps_catergories.catid.

[r937]

no, coil, those would the the first 10 titles overall

snaggle, er, i mean sabret00the wants 10 per category

something like this --

select C.title      as catname
     , G1.title     as groupname
     , G1.description
     , G1.leaderid 
  from grps_catergories as C
inner
  join grps as G1
    on C.catid = G1.catid
   and G1.approved = 1 
inner
  join grps as G2
    on C.catid = G2.catid
   and G2.approved = 1 
   and G1.title >= G2.title
group 
    by C.title    
     , G1.title   
     , G1.description
     , G1.leaderid 
having count(*) <= 10     
order 
    by G.title

[sabret00the]

thanks rudy i'll try this out