title: Cartesian join two tables with no records
body: <p>I have to join Table A (tax related) to Table B (customer related)</p>
  
  <p>I pull at most 1 record but sometimes no record.</p>
  
  <p>Now I need to return the combined record to the user</p>
  
  <p>I though doing a simple Cartesian product would have work</p>
  
  <pre><code>SELECT * FROM TableA, TableB
  </code></pre>
  
  <p>but that does not work if TableA or TableB is empty</p>
  
  <p>I would do a full outer join but right now do not have anything to join on.  I could create temp tables with identity columns and then join on them (since 1 = 1)</p>
  
  <p>But I was looking for a different way?</p>
  
  <p>Thank you </p>