title: Gain names of the column based on comparision between tables
body: <p>My goal is to retrieve a result of the name of column based on similiar column from table Product_A and Product_B.</p>
  
  <p>It doesn't matter if I gain the result in excel, notepad or table from sql server. The most important is to retrieve the result.</p>
  
  <p>I don't know how to retrieve the result based on calculation with low usage of manual work?</p>
  
  <p>Some criteria you need to take account to:</p>
  
  <ul>
  <li>The column must have the same datatype and name to be similiar</li>
  <li>I'm not interrested in retrieving the data from the column</li>
  <li>The table is created in a basic level. In reality, the table use 200 column.</li>
  </ul>
  
  <p>The table is in SQL server 2008 R2</p>
  
  <pre><code>TABLE Product_A
  (
     ProductID INT,
     ProductName VARCHAR(100),
     Rate MONEY,
     Action INT,
     MapINT,
  ) 
  
  
  TABLE Product_B
  (
     ProductID INT,
     Count INT,
     ProductName VARCHAR(100),
     Rate MONEY
  ) 
  
  
  
  Requested result
  
         ProductID INT,
         ProductName VARCHAR(100),
         Rate MONEY,
  </code></pre>