help by where statement

[Felix Wackernagel]

Hello developer i am not a sql guru and so i need some help to realise my where statement with ormlite.

My database model looks like this:

My goal is to compare the amount of my actual recipe_ingredient_relations with the amount of all items they my ingredient from recipe_ingredient_relation can has.
I mean each ingredient can have many items. Each item has a amount. Now i want to compare the amount from recipe_ingredient_relations with the amount of each item.

I hope this is enough information for my problem to come to a solution. I can post my model code if it is needed.