title: SQL Server query with same functionality as Excel VLookup
body: <p>I have 2 columns of data that I need to compare with each other - Column A and Column B.</p>
  
  <p>Column A:</p>
  
  <pre><code>Steve
  Jane
  Mary
  Peter
  Ed
  Scott
  Ted
  </code></pre>
  
  <p>Column B:</p>
  
  <pre><code>Peter
  Scott
  David
  Nancy
  </code></pre>
  
  <ul>
  <li>Column A has a larger amount of data than column B.</li>
  <li>But it may not have all the values in column B.</li>
  </ul>
  
  <p>I need to find out which of the values in column B are also in column A.</p>
  
  <p>Output expected for above sample data:</p>
  
  <pre><code>Peter   TRUE
  Scott   TRUE
  David   FALSE
  Nancy   FALSE
  </code></pre>
  
  <ul>
  <li>Need to use SQL Server / T-SQL to get this output.</li>
  <li>Column A and Column B are fields in 2 separate tables</li>
  <li>There are no other columns in the 2 tables</li>
  </ul>
  
  <p>Thanks for all your help!</p>