title: Combining select and select union in SQL Server
body: <p>I have 2 tables</p>
  
  <ul>
  <li>Table A with 3 columns : <code>ID, NAME, VALUE 1</code></li>
  <li>Table B with 3 columns : <code>ID, NAME, VALUE 2</code></li>
  </ul>
  
  <p>Table A :
  ID : A1, A2
  NAME: AAA, BBB
  VALUE 1 : 1000,2000</p>
  
  <p>Table B :
  ID : B1, B2
  NAME: CCC,DDD
  VALUE 1 : 3000,4000</p>
  
  <p>And I want to show the result like this :</p>
  
  <p>ID, NAME, VALUE 1, VALUE 2
   A1  AAA      1000
   A2  BBB       2000
   A3  CCC                        3000
   A4  DDD                        4000</p>
  
  <p>I have tried <code>union</code> and it works for <code>id, name</code> column. What about regular <code>select + union select</code>, is it possible ?</p>