title: In SQL Server, How to join two table having different column name and different data row?
body: <p>Suppose I have two tables <code>T1</code> &amp; <code>T2</code>. I want resulting output table as O1 with help of a SQL query</p>
  
  <pre><code>T1 {SName} 
  T2 {VName} 
  
  O1 {SName, VName}
  </code></pre>