title: Getting data from three tables. Should I join them?
body: <p>I have three tables I'm trying to use.</p>
  
  <p>Author      (AuthorID, Lname, Fname)</p>
  
  <p>Book Author (ISBN, AuthorID)</p>
  
  <p>Books       (ISBN, Title)</p>
  
  <p>Need to display it like this:</p>
  
  <pre><code> AUTH LNAME     FNAME     TITLE
   ---- -----------------------------------------------
   S101 Smith     Roger     TRAVELING TO FRANCE         
   S101 Smith     Roger     HOW TO BAKE A CAKE
   J101 Wilson    Kenny     ADVENTURES OF THE MAN              
   P101 Peters    Lemon     SCIENCE AND MATH 
   S101 Fogo      Baker     SCIENCE AND MATH
  </code></pre>
  
  <p>The closest I can is this:</p>
  
  <pre><code> SELECT authorid, title
   FROM bookauthor, books
   WHERE book author.isbn = books.isbn
  </code></pre>
  
  <p>Which gives me:</p>
  
  <pre><code> AUTH TITLE                        
   ---- ------------------------------
   S101 TRAVELING TO FRANCE          
   S101 HOW TO BAKE A CAKE         
   J101 ADVENTURES OF THE MAN             
   P101 SCIENCE AND MATH
   S101 SCIENCE AND MATH
  </code></pre>
  
  <p>But that leaves out the first and last name, which I'm trying to include.</p>
  
  <p>I looked at other questions regarding joining tables but I can't seem to apply it to my script.  Beginner at Oracle SQL so any help is appreciated.</p>