title: INNER JOIN on 3 tables. SQL
body: <p>Trying to make a query which prints out book title (in book table) and the author's name (in author table) but from a separate table that has all the book ID's of a certain sales rep. A picture of the tables in this link: <a href="http://i.imgur.com/0xybMIG.png" rel="nofollow">http://i.imgur.com/0xybMIG.png</a></p>
  
  <p>My code so far is </p>
  
  <pre><code>SELECT book.title, author.fName, author.surname
  FROM author 
  INNER JOIN book ON author.aID = book.authorID 
  INNER JOIN SeanWalshOrders ON book.isbn = SeanWalshOrders.bookID;
  </code></pre>