title: MYSQL nested inner join query
body: <p>I wanted to create a nested query that on the outside gets the title and price from a table called 'Books' while having a nest inside the query that gets the Author's First and last name for that specific book. I'm just a little confused on the Inner Joins and where they need to be placed. This is as close as I was able to get with it but this just prints every author for every book.</p>
  
  <pre><code>select Title, AuthorFirst, AuthorLast,Price from Book
  JOIN
  (select AuthorLast,AuthorFirst from Author 
  INNER JOIN Wrote on Author.AuthorNum = Wrote.AuthorNum 
  INNER JOIN Book on Wrote.BookCode = Book.BookCode group by title desc)Auth;
  </code></pre>
  
  <p>This joins the tables that I need but it prints every author in the DB with every book in the database. I think it has something with my Inner Joins not being specific enough.</p>