[SOLVED] How to get specific stats.

[pureDesi]

I'm new to MySQL and couldn't figure this out for the life of me, I'm trying to pull out stats for a game from another table with a restriction, see below.

SELECT gameID, gameTitle, gameUnique, COUNT(mapID)
FROM games, maps
WHERE gameEnabled=1 AND mapParentID = gameID
ORDER BY gamePriority DESC, gameTitle ASC

It's intention is to pull all the games out (if it's enabled) and count how many maps are in each game from a separate table, "maps".

I'm completely lost as to how I would use GROUP BY. Any help would be appreciated

Thanks for your time

-pure

[bubblegum.anarchy]

The GROUP BY value is what identifies each unique group of records - maybe mapParentID

[pureDesi]

Ah! I appreciate the help, and it now works!