Does Firebird support deletes and/or updates with subquery?.
Something like this:

DELETE FROM RECIPES
WHERE R_ID = ( SELECT R_ID FROM INGREDIENTS
WHERE NAME='RICE' )

Thanks