title: merge results from multiple select statements on single table
body: <p>I have two select statements</p>
  
  <pre><code>SELECT username, password FROM users WHERE username='$Uname'
  </code></pre>
  
  <p>and </p>
  
  <pre><code>SELECT email_address FROM users WHERE email_address='$email'
  </code></pre>
  
  <p>What statement can I use so I get all results at once i.e </p>
  
  <p>username  as result[0], password as result[1] and email_address as result[2]</p>
  
  <p>To explain better.</p>
  
  <p>I want to check if there is already a record of the username in my database if so then grab the password and then also check if the password there is a record of the email_address as well to ensure users are no allowed to have duplicate usernames or email addresses.</p>