SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Member
    Join Date
    Mar 2005
    Posts
    1
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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.

    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


  2. #2
    Gone!
    Join Date
    Aug 2001
    Location
    Witty Location Parody
    Posts
    3,889
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Moved to the correct forum.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •