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
Friday, February 24, 2012
List from three tables
Labels:
category,
database,
family_namebooksisbn,
first_name,
hereinventoryisbn,
microsoft,
mysql,
num_pages,
oracle,
quantityauthorsid,
server,
sql,
status,
status_date,
tables
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment