title: SQL Join two tables without Relations
body: <p>I have different tables with the same structure, and I would like to join them by one of their columns. </p>
  
  <p>The problem is that they don't share information in that column.</p>
  
  <pre><code>Table 1 - Type A:
  
  Name | Value
  
  Table 2 - Type B:
  
  Name | Value
  </code></pre>
  
  <p>Resulting table:</p>
  
  <p>(In a single column)</p>
  
  <pre><code>nameFromA
  
  nameFromB
  ...
  </code></pre>
  
  <p>So far, I have tried:</p>
  
  <pre><code>SELECT TABLE1.NAME, TABLE2.NAME 
  FROM TABLE1, TABLE2 
  WHERE TABLE1.NAME = 'SearchQuery'
  OR TABLE2.NAME = 'SearchQuery' LIMIT 2;
  </code></pre>
  
  <p>I know that my query is wrong because I'm calling more columns that what I want, but I am not sure how to join everything in a single column.  How can I accomplish this?</p>