title: Get all Columns of One table having one column which has to derive data from another table corresponding to its data
body: <p>Consider a table</p>
  
  <p>PRODUCTSTABLE</p>
  
  <pre><code>product_id | product_name | product_country
  1          | ABC          | 1    
  2          | DEF          | 3    
  3          | ASD          | 2    
  4          | JGH          | 3    
  5          | WER          | 2
  </code></pre>
  
  <p>COUNTRY TABLE</p>
  
  <pre><code>country_id | country_name
  1          | Japan
  2          | China
  3          | Uganda
  4          | France
  5          | United States
  </code></pre>
  
  <p>I want to get results like as this query would produce</p>
  
  <pre><code>SELECT * FROM PRODUCTSTABLE;
  </code></pre>
  
  <p>The only difference would be in the third column 'product_country', instead of number respective Country name referenced from the second table must come.</p>
  
  <p>Thank you.</p>