title: SQL find the same column in different tables
body: <p>I have 2 very large tables. I try to figure out what they have in common.</p>
  
  <p>They do not have the same numbers of columns. I could go about to just look at each column name from each table and compare - but they both have hundreds of columns (I have to do it for many such tables).</p>
  
  <p>I use MS Sql server.</p>
  
  <p>There are no constrains and no foregin keys on any of them.</p>
  
  <p>How do I go about doing that ?</p>
  
  <p>Something like this:</p>
  
  <pre><code>select * AS "RES" from Table1 where RES IN (select * column from Table2)
  </code></pre>
  
  <p>Thanks in advance.</p>