title: Comparing two tables in a database matching values and writing/merging to a new table
body: <p>I am trying to do a simple match up my IDs in my database and collate all information into the one table. My database details are as follows.</p>
  
  <pre><code>Database Name: test
  Table Names: password, username
  Password Table contains: id, password
  Username Table contains: id, username
  </code></pre>
  
  <p>Can anyone please provide me with some code examples so I can read the relevant username and password next to each other in one list without having to crossreference between the two tables, matching up the ID? for example a table like</p>
  
  <pre><code>ID, Username, Password
  </code></pre>