SELECT DISTINCT combattre.nom, habitant.libfonction from combattre,habitant where combattre.nom = habitant.nom order by combattre.nom ASC ;
+-----------------+-------------+
| nom             | libfonction |
+-----------------+-------------+
| assurancetourix | barde       |
| astrix          | guerrier    |
| cetautomatix    | guerrier    |
| oblix           | guerrier    |
| unix            | guerrier    |
+-----------------+-------------+
5 rows in set (0.00 sec)