There are two tables ‘book’ & ‘author’.
We need a query to retrieve all books written by an author.
Primary key of ‘book’ is bookid, and of author.. it is ‘author id’.
There is another table ‘bookdetails’ which contains the field bookid, authorid

Kindly help..

Thank You..