5 different meals at the same price with name of ingredients (was "sql problem")

[sobowao]

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.

tables enclosed:


meal

meal code
description
cost

Ingredients

meal_code
supplier code
ingredients

Supplier

supp_code
address line1
address line2
tel_no
supp_name

Bookings

cust_name
phone_no
time
no_of_people

Staff

Staff_no
name

Thanks for any help

[Dan Morgan]

Moved to the correct forum.