Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2012

    Unanswered: SQL query help needed

    I'm having major difficulty in solving these four queries and would really appreciate some help, i've just started SQL and yes I am a student so i'm learning and I am really stuck on some work, any help provided would be thoroughly appreciated. Thank you!


    1) List the Name of each Supplier with the Location of each Warehouse and the number of Products supplied by that supplier and Stocked at that Warehouse

    what i have done so far: buts its not displaying the products that are supplied.

    select, w.location
    from supplier s
    join product p
    on s.supplier_no = p.supplier_no
    inner join warehouse w on P.supply_warehouse_no = w.warehouse_no
    Last edited by JK123; 01-08-13 at 09:32.

  2. #2
    Join Date
    Feb 2004
    In front of the computer
    Provided Answers: 54
    You're looking for a Count(*), which implies that you'll need a GROUP BY too.

    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

Tags for this Thread

Posting Permissions

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