I'm writing a query whereby I'm trying to count the total number of records in report and assignment table, whiles at the same time retrieving information from the main table group. Group has a primary key id which is saved in the other tables as gid. This is the query:

```
SELECT  `group`.`id` AS `gid`
        , `group`.`name` AS `g_name`
        , COUNT(`report`.`id`) AS `reports` 
FROM    `group` 
        LEFT OUTER JOIN `report` ON `report`.`gid` = `group`.`id` 
        LEFT OUTER JOIN `assignment` ON `assignment`.`gid` = `group`.`id` 
WHERE   `group`.`active` = 0 
ORDER BY 
        `group`.`name`;

```

My problem is whenever I execute this only one record is returned even if theirs multiple groups.

Thanks in advance.