title: Fetching rows from two tables using single query
body: <p>I have two tables say Table A and Table B. The table A and B do not have direct relationship with each other. Need to fetch list of rows combining data of both the tables after applying sort based on combination of certain columns from both the tables.</p>
  <p>Eg</p>
  <pre><code>Table A
  id.    name.   age
   1.    test.   11
  
  Table B
  id.      user name.    age
  1        test1         12
  </code></pre>
  <p>Expected result</p>
  <pre><code>A.id.    B.id.    name   user name
  
  1        null     test.   null
  null     1        null    test1
  </code></pre>
  <p>Here sort is done based on column age from both the tables.</p>