SQL Server query with same functionality as Excel VLookup

Question

I have 2 columns of data that I need to compare with each other - Column A and Column B.

Column A:

Steve
Jane
Mary
Peter
Ed
Scott
Ted

Column B:

Peter
Scott
David
Nancy

• Column A has a larger amount of data than column B.
• But it may not have all the values in column B.

I need to find out which of the values in column B are also in column A.

Output expected for above sample data:

Peter   TRUE
Scott   TRUE
David   FALSE
Nancy   FALSE

• Need to use SQL Server / T-SQL to get this output.
• Column A and Column B are fields in 2 separate tables
• There are no other columns in the 2 tables

Thanks for all your help!

Answer 1

select 
   b.columnb,
   case when a.columna is null then 'FALSE' else 'TRUE' end 

from
   tableb b left outer join
   tablea a on b.columnb = a.columna