title: How to retrieve data from two tables? Do I have to use join?
body: <p>I have two tables, users and favourite songs. </p>
  
  <p>The user registers to the site, and has to login. So the query for that is:</p>
  
  <pre><code>SELECT * FROM users WHERE Username='$Name' AND Password='$Pass'
  </code></pre>
  
  <p>The favourite songs table also has their username in it. How do I change the query so that their favourite song is also selected? Once logged in, I want the song echoed back to them.</p>
  
  <p>Song table:</p>
  
  <pre><code>Username  Song:
  test1   | Singing in the rain
  test2   | Nightdance
  test3   | Firestorm 
  </code></pre>
  
  <p>Users table:</p>
  
  <pre><code>Username  Password
  test1   | 123123
  test2   | 123123
  test3   | 123123
  </code></pre>