title: How to join 3 tables
body: <p>I have 3 tables,one for Study and the others are Travel and Country.Study. 
  <code>Study</code>  table contains <code>StudyID,StartDate,EndDate,CountryID</code> and set <code>StudyID</code> as <code>primary key</code>.</p>
  
  <p><code>Travel</code> table contains <code>TravelID,StudyID,CountryID,TravelStartDate,TravelEndDate</code> ,<code>TravelID</code> as <code>Primary key</code> and <code>StudyID</code> as <code>Foreign key</code>.</p>
  
  <p><code>Country</code> table contains <code>CountryID,CountryCode,CountryName, CountryID</code> as <code>primary key</code>.</p>
  
  <p>I want to get <code>CountryName</code> like <code>"CountryCode+' - '+CountryName as CountryName".</code></p>
  
  <p>I have the following query:</p>
  
  <pre><code>SELECT
              Study.CountryID
                         ,Travel.CountryID
                         ,StartDate   
                         ,EndDate
                         ,TravelStartDate,TravelEndDate,
                 , CountryCode+' - '+CountryName as CountryName,              
  
                        FROM dbo.Study left join  dbo.Countries
                        on 
                        Study.CountryID=Countries.CountryID
                       left join Travel 
                        on 
                       Travel.StudyID=Study.StudyID
  </code></pre>
  
  <p>I want to display the <code>CountryName</code> for <code>Travel</code> and <code>Study</code>. How can I display one country for travel and one for study ?</p>