title: Joining on a one-row table: subquery or cross join?
body: <ul>
  <li><p><em>query no.1</em></p>
  
  <pre><code>select 
        table2.someClmn,table1.name,table1.address 
  from 
        table1 cross join table2 
  where table1.id = 123
  </code></pre></li>
  <li><p><em>query no.2</em></p>
  
  <pre><code>  select 
         (select someClmn from table2),table1.name,table1.address 
    from table1
    where table1.id = 123
  </code></pre></li>
  </ul>
  
  <hr>
  
  <p>Both <em>queries</em> return exact same result so which is good to use?<br>
  NOTE: in my case <code>table2</code> contains single row only</p>
  
  <hr>
  
  <p>EXPLAIN ANALYZE for <a href="http://explain.depesz.com/s/1yUs" rel="nofollow"><em>query no.1</em></a> and <a href="http://explain.depesz.com/s/SLTG" rel="nofollow"><em>query no.2</em></a></p>