title: Combining multiple tables in SQL
body: <p>I need a result set of multiple tables combined. 
  I have a query with a from clause using a table for each country that are selected in the parameter.</p>
  
  <p>Ex:</p>
  
  <pre><code>@prmCountry='AU,UK,US'
  </code></pre>
  
  <p>Now in the from clause the table name is as such that it has to run for each country separately:</p>
  
  <pre><code>from tbl_abc t1
  left outer join tbl_country_(CountryName) t2
  on.....
  </code></pre>
  
  <p>How to exactly do this?</p>