title: MySQL Understanding Basic Joins
body: <p>I am struggling to understand basic MySQL joins.</p>
  <p>Basically I've got 2 tables one with a customer first name and address id in it and another with the actual address.</p>
  <p>Rather than just displaying the customer name and an address id I want it to display the customer name and the actual address.</p>
  <p>My basic select statement is like this:</p>
  <pre><code>SELECT firstName, addressId FROM Customer
  </code></pre>
  <p>It will display something like this:</p>
  <pre><code>firstName   addressId
  ---------------------
  Bob         56
  </code></pre>
  <p>Rather than than I would like to join the addressId with an actual address in another table</p>
  <p>Like this:</p>
  <pre><code>firstName    address
  ----------------------------------
  Bob          45 Somewhere street
  </code></pre>
  <p>Is there anyone who can show me the best way to achieve this?</p>
  <p>Also can anyone recommend a good tutorial for joins?</p>