title: How to determine which columns are shared between two tables?
body: <p>Very new to SQL Sever here... I understand the concept of joining tables, etc. but what is the easiest way to determine which columns are shared? </p>
  
  <p>Say for instance we have Table 1 and Table 2, assume table 1 has over 100 columns as does table 2, but they only have 1 column in common.</p>
  
  <p>Is there a simple way to check to see what column / if any are shared without annoyingly going in and checking?</p>
  
  <p>Pretty trivial question but very useful. Thanks </p>