Try querying the database directly for each table, then both tables using a DB tool to check that your query is logically correct before trying to implement it at your front-end.

If parent table only has one relevant row, and child has only one rows with VALIDITE = 'O' then it is expected that you will get only one row in result of join e.ITEM_NBR = a.ENFANT.