if you want to retain all child records then do a left join on e.ITEM_NBR = a.ENFANT and remove validite condition.