Friday, February 24, 2012

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!!!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|||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.|||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?|||In any case, read the sticky at the top of the board, and post what it asks for...I'm tired of typing

No comments:

Post a Comment