Share
Explore BrainMass

Author and tittles

Using the week 2 lecture/homework database, show the author and titles of books that have never sold.

Here is the SQL for my question, but what are the author and titles of the books that did not sell?

select books.title ,books.author_name from books where books.isbn not in ( select isbn from order_lines where shipped='Y' );

Attachments

Solution Preview

This will return all author and titles of books that have never sold.

select books.title ...

$2.19