Every derived table must have its own alias!

Databases
2

If that is how the table is then this will work (Rudy will probably come up with an easier way

SELECT
    recette_1 AS recette
FROM
    (
        SELECT
              ingredient AS ingredient_1
            , recette AS recette_1
        FROM
            recipe
        WHERE
            ingredient = 'pois'
    ) AS ingredient_1
INNER JOIN
    (
        SELECT
              ingredient AS ingredient_2
            , recette AS recette_2
        FROM
            recipe
        WHERE
            ingredient = 'rhum'        
    ) AS ingredient_2
ON ingredient_1.recette_1 = ingredient_2.recette_2