title: Multiple SQL joins
body: <p>I need to execute a query To retrieve data from multiple tables but I'm rather confused on how to do it all at once. </p>
  
  <pre><code>Books: _ISBN , BookTitle, Edition, Year, PublisherID, Pages, Rating
  Categories: _CategoryID, Category
  Categories_Books: _Categories_Category_ID, _Books_ISBN
  Publishers: _Publisherid, Publisher
  Writers: _WriterID, LastName
  Writers_Books: _Writers_WriterID, _Books_ISBN
  </code></pre>
  
  <p><code>Categories_Books</code> and <code>Writers_Books</code> are the intermediate tables to help me implement many to many relationships between the tables. </p>
  
  <p>I need a single query with multiple joins to select:</p>
  
  <ul>
  <li>Title, Edition, Year, Pages, Rating from Books</li>
  <li>Category from Categories</li>
  <li>Publisher from Publishers</li>
  <li>LastName from Writers</li>
  </ul>