title: How to get two values from table based on different id's in same SELECT
body: <p>I have two tables:</p>
  
  <pre><code>Users
  =====================================
  id, name, country_id, nationality_id
  
  Countries
  =====================================
  id, name, currency
  </code></pre>
  
  <p><code>country_id</code> and <code>nationality_id</code> both use id's from the Countries table.</p>
  
  <p><code>country_id</code> and <code>nationality_id</code> are not necessarily the same.</p>
  
  <p>What I want to get is a table with the name of each user in a given country, the name of their country by <code>nationality_id</code> and the currency they use by <code>country_id</code>.</p>
  
  <p>My problem is how to do the WHERE clause.  This is what I have but it is incorrect because the currency comes back by <code>nationality_id</code> instead of <code>country_id</code>.</p>
  
  <p>Hope that makes sense....</p>
  
  <pre><code>SELECT
      Users.name,
      Countries.name,
      Countries.currency
  FROM
      Users, Countries
  WHERE
      Users.nationality_id = Countries.id 
  AND Countries.id = 6
  </code></pre>