title: Select 3 columns from different tables into one column
body: <p>I'd like to combine 3 different columns witch are contains company names but stored in different groups! </p>
  
  <p>Like: </p>
  
  <ol>
  <li>Company_inland</li>
  <li>Company_import</li>
  <li>Company_import_group</li>
  </ol>
  
  <p>Each category comes from a temporary table, and after I have to combine all the fields into one column I'll tried the following lines but I got 0-values for all.</p>
  
  <pre><code>select (hamburger_belfold.Szallito_nev +' '+ hamburger_import.szallito_nev +' '+ hamburger_import_group.szallito_nev ) as 'Szállitó' 
  from hamburger_belfold,hamburger_import,hamburger_import_group;
  </code></pre>
  
  <p>and I want something like this:</p>
  
  <pre><code>Combine Table |
  Company 1     |from table 1
  company 2     |from table 1
  company 3     |from table 1
  
  company 4     |from table 2
  company 5     |from table 2
  company 6     |from table 2
  
  company 7     |from table 3
  company 8     |from table 3
  company 9     |from table 2
  </code></pre>