Jointure tout bête

mysql> DESCRIBE articles;
+-------+-------------+------+-----+---------+----------------+
| Field | Type        | Null | Key | Default | Extra          |
+-------+-------------+------+-----+---------+----------------+
| id    | int(11)     | NO   | PRI | NULL    | auto_increment |
| nom   | varchar(42) | NO   |     | NULL    |                |
+-------+-------------+------+-----+---------+----------------+
2 rows in set (0.00 sec)

mysql> DESCRIBE commentaires;
+------------+---------+------+-----+---------+----------------+
| Field      | Type    | Null | Key | Default | Extra          |
+------------+---------+------+-----+---------+----------------+
| id         | int(11) | NO   | PRI | NULL    | auto_increment |
| id_article | int(11) | NO   |     | NULL    |                |
+------------+---------+------+-----+---------+----------------+
2 rows in set (0.00 sec)

mysql> 

mysql> SELECT articles.id, articles.nom, COUNT(commentaires.id) AS 'nb_commentaires' FROM articles LEFT OUTER JOIN commentaires ON articles.id = commentaires.id_article GROUP BY articles.id;
+----+------+-----------------+
| id | nom  | nb_commentaires |
+----+------+-----------------+
|  1 | plop |               0 |
|  2 | plip |               6 |
+----+------+-----------------+
2 rows in set (0.01 sec)

mysql>