5 different meals at the same price with name of ingredients (was "sql problem")
hello, I am trying to write an sql query that will pull information from several tables I have created. This is based on booking in a chinese restaurant for meal either 1 or 2 or 5
all at the same cost.
The restaurant will also have suppliers supplying ingredients used in preparinf the meals.
Staff now serve the meal to the public.
The tables created are attached as follows:
My question is what query do I need to create if a customer wants 5 different meal @ same price with the name of ingredients used.
Also if it was 1 meal a customer need.
If a customer wants about 5 different meal and staff at the restaurant needs to know how many people so that seat can be reserved for them.
How can I join this query together to achieve my goal.