title: How to join 2 tables with no common column in sql
body: <p>eg</p>
  
  <p>Names</p>
  
  <pre><code>id  | name
  1      abc
  2      efg
  </code></pre>
  
  <p>Area</p>
  
  <pre><code>id  | areaName
  3     area1
  4     area2
  </code></pre>
  
  <p>The query should return</p>
  
  <pre><code> id  | name | areaid
   1     abc    3
   1     abc    4
   2     efg    3
   2     efg    4  
  </code></pre>