Simple SQL redux :)

[Al Neri]

Im looking to write a query. Who's read what book (by reader) and who's read what book (by book)

Here's a description of my tables http://www.javadimension.com/mysql.JPG

little help? I tried,

SELECT bookname, firstname FROM firstname, books, booksread WHERE books.bookid=1 AND firstname.firstnameid=booksread.firstnameid ORDER by bookname asc

to see who read catch22 but no dice........

it results:

Catch 22 Mike
Catch 22 Mike
Catch 22 Mike
Catch 22 Bob
Catch 22 Bob
Catch 22 Taco
Catch 22 Sam
Catch 22 Sam

Thanks !
Don R.

 

[MrChad]

Close ... you need one more JOIN

SELECT bookname, firstname FROM firstname, books, booksread WHERE books.bookid=1 AND firstname.firstnameid=booksread.firstnameid AND books.bookid = booksread.bookid ORDER by bookname asc

 

[Al Neri]

sexcellent
@!