I'm trying to design a drink database and need some help with the design.

I created the following tables: an ingredients table that lists all possible ingredients (i.e. rum, coke, vodka and orange juice). A drinks table with a list of all possible drinks (i.e. "rum & coke", "screwdriver"). Finally a Recipes tables describes how to make the drink, so for "rum & coke" there are two entires one with the ingredients ID for rum and one for ingredients ID for coke both with a foreign key to the same drink id.

What I want to do is given a list of available ingredients id - 1(rum), 2(coke) and 3(vodka) I want to come up with a list of drinks that are possible to make. So I can make rum & coke but not a screw driver because I don't have orange juice.

Any suggestions on how to write such a select statement or how to better design the tables?

Thanks

teh tabl dezigngs are okj hic

what if you have ony 2 oz of vodka, hell, i have even less but i'm saving the last swig

so you need "qty" quantititity (heh) column as well eh

hey i still have half a bottle of rum here

do you wnat your query to be able to make any qty drink?

like for instance a really dry martini is mostly gin and kind of wave the vermouth cork over the glass

i speak from considerable experience

hey i still have almost half a bottle of rum here

Quoted for truth.

That's for the reply - I don't need to query for the quantity I'm assuming there's always plenty of liquor to go around.

I have my doubts about that especially with those two topers on your case