Davin Martyn

Davin Martyn

  • NA
  • 7.5k
  • 3m

Compare and find match record

Apr 29 2015 8:39 AM
Hi,
I am working in sqlserver i have two table one table contain coloumn
 
Name , agency, gm
 
and second coloumn
 
First name, last name  , manager
 
i want to compare both table and find match record against the name 
output find
 
name ,first+last name,  matchrecord  threcoloumn
 
how to find. 

Answers (5)