title: How to join 3 tables (1 lookup) with SQL
body: <p>I am trying to join 3 different tables but having difficulty following the logic in other tutorials.</p>
  
  <pre><code>table_1(user_ID, seller_country_ID)
  table_2(user_ID, users_country_ID)
  table_3(country_ID, country_Name)
  </code></pre>
  
  <p>I am trying to create a query that returns sellers country name and the users country name. I can use a join to get the sellers country name, but my logic abilities stop there when it comes to getting the users country name. I have a WHERE clause that further restricts the records returned and that needs to be there.</p>
  
  <pre><code>SELECT tbl1.user_ID, tbl1.seller_country_ID, tbl3.country_Name
  FROM table_1 AS tbl1
  JOIN table_3 AS tbl3
  ON tbl1.seller_country_ID = tbl3.country_ID
  WHERE &lt;sales_type&gt; = 1
  </code></pre>
  
  <p>So, I've got tables 1 and 3, but not sure how to incorporate table 2 to get my results.</p>
  
  <p>Results I am seeking are:</p>
  
  <pre><code>user ID, user_country, seller_country
  010101, USA, CANADA
  </code></pre>