title: SQL JOIN without excess info
body: <p>I've spent about an hour and a half trying to work this out, and I'm sure its because its not the best function to use, but I need to for my assessment. </p>
  
  <p>The idea is I have 3 tables, and want to return all the information for each 'guestName' along with its related 'hotelName', 'roomNo' and 'dateTo' cells. I can't work out how to make this work with a simple Join.</p>
  
  <pre><code>SELECT guestName, hotelName, roomNo, dateTo 
  FROM guest 
  JOIN hotel, booking 
  ORDER BY guestName
  </code></pre>
  
  <p>This is just returning every entry from all the tables I have joined with, repeating guest names and hotel names to fit the room number and date to columns.</p>
  
  <p><a href="https://i.stack.imgur.com/qUloj.png" rel="nofollow">JOIN error</a></p>
  
  <p>Each SELECT item has its own table, except 'roomNo' which is within the booking table. All my searching just tells me to use other methods of JOIN, which I'm sure works better,  but those are coming up in later assessment pieces so I need to use standard JOIN. </p>
  
  <p>Cheers for any direction on this.</p>