mysql> SELECT distinct habitant.nom from habitant,menhir,manger where ((habitant.nom = manger.nom) AND !(habitant.nom = menhir.nom) );
+-----------------+
| nom             |
+-----------------+
| astrix          |
| oblix           |
| ordrealphabetix |
+-----------------+
3 rows in set (0.00 sec)