title: I want to join five tables in MySQL
body: <h2>Books</h2>
  
  <ul>
  <li>bookid (PK)</li>
  <li>title</li>
  <li>price</li>
  </ul>
  
  <h2>author</h2>
  
  <ul>
  <li>authored (PK)</li>
  <li>authorname</li>
  </ul>
  
  <h2>publisher</h2>
  
  <ul>
  <li>pubid (PK)</li>
  <li>pubname</li>
  </ul>
  
  <h2>bookauthors</h2>
  
  <ul>
  <li>bookid (FK)</li>
  <li>authorid</li>
  </ul>
  
  <h2>bookpublisher</h2>
  
  <ul>
  <li>bookid (FK)</li>
  <li>pubid</li>
  </ul>
  
  <p>I want to join all five tables and get these column values:</p>
  
  <ul>
  <li>bookid</li>
  <li>title</li>
  <li>price</li>
  <li>authorname</li>
  <li>pubname</li>
  </ul>
  
  <p>I should get only one row for a query to get above result. What I wrote was: </p>
  
  <pre><code>select books.*, authors.authorname
  from authors,books
  inner join bookauthors on books.bookid = bookauthors.bookid
  inner join publisherbook on books.bookid = publisherbook.bookid
  where books.bookid = 459567;
  </code></pre>
  
  <p>but instead I am getting many rows with duplicate data. </p>