MySQL > Select4

--8
SELECT vchTitreRecette FROM recettes
LEFT JOIN recettes_adresse_public USING(idRecette)
LEFT JOIN public_cible USING(idPublic)
LEFT JOIN plats USING(idPlat)
LEFT JOIN recettes_contient_ingredients USING(idRecette)
LEFT JOIN ingredients USING(idIngredient)
LEFT JOIN difficultes USING(idDifficulte)
WHERE vchNomPublic = "enfant" AND vchNomPlat = "entrées" AND vchNomIngredient = "fenouil" AND vchNomDifficulte = "facile"