title: Join on two tables having single columns with no matching condition
body: <p>I have codes table with following data</p>
  
  <pre><code>_________
  dbo.Codes
  _________
  AXV
  VHT
  VTY
  </code></pre>
  
  <p>and email table with the folowing data</p>
  
  <pre><code>_________
  dbo.email
  _________
  x@gmail.com
  y@gmail.com
  z@gmail.com
  </code></pre>
  
  <p>and I am looking forward to join these two tables horizontally with the following output.</p>
  
  <pre><code>__________
  dbo.output
  __________ 
  AXV    x@gmail.com
  VHT    y@gmail.com
  VTY    z@gmail.com
  </code></pre>
  
  <p>Is there any way possible to get the desired output?</p>
  
  <p>Edit #1
  Both the tables contain unique codes and unique email addresses</p>