Actually, you can with joins:
[code]SELECT r.id AS recipe_id, r.name, ri.ingredient_id, i.item
FROM recipes r
JOIN recipe_ingredients ri ON (r.id = ri.recipe_id)
JOIN ingredients i ON (ri.ingredient_id = i.id)
JOIN recipe_ingredients ri2 ON (r.id = ri2.recipe_id)
JOIN ingredients i2 ON (ri2.ingredient_id = i2.id)
where
i.Item = ‘apple’ and
i2.Item = ‘sugar'[/code]