title: join two select statements side by side Sql
body: <p>I have two select query statements. I dont know to create table here. </p>
  
  <p>Below are two tables. Id is same, but Fname and Lname is different.</p>
  
  <p>Table1 have two columns </p>
  
  <pre><code> id Fname 
   1  Ahila 
  </code></pre>
  
  <p>Table2 have two columns </p>
  
  <pre><code> id Lname 
    1 Kavitha 
  </code></pre>
  
  <p>Output table should be single row with id and Fname and Lname : 1 and Ahila and Kavitha respectively</p>
  
  <p>Please help me on this.</p>