Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2002
    Posts
    59

    Unanswered: List from three tables

    HI I have three tables as here:

    inventory
    isbn, status, status_date, quantity

    authors
    id, first_name, family_name

    books
    isbn, category, title, num_pages, price, copyright, author1, author2, author3


    How can I list title and author name of the book that is most in stock?

    My another problem to

    Listing names of authors who have not written ay books

    Thanks folks!!!

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    these are homework questions, and we do not do homework on this site

    however, we would be happy to help you if you have any difficulty

    try the queries yourself, and show us the results or any error messages
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Nov 2002
    Posts
    59
    No this is not HW question...

    I have just simplified my problem to get help faster but seems like wasnt the right way to do it.

    Anyways thank you.

  4. #4
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    well, if it is not a homework question, then you won't mind trying the queries yourself and showing us what you came up with, right?
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  5. #5
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    In any case, read the sticky at the top of the board, and post what it asks for...I'm tired of typing
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

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