Compare and find match record

Question

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.

Davin Martyn · Answer

my condition is : compare first +''+ lastname with name when name match then show agency coloumn record like according to match record . Example : Name = RajeshTripathi FIRST+''+LAST = rajesh tripathi then agency column display record if not match then agency column display 'n/a'

Khargesh Rajput · Answer

use select name from firsttable where name in (select (First name+last name) from secondtable) and which table you have agency for agency display you can use case statement according to your condition

Davin Martyn · Answer

HOW TO JOIN ON NAME PLEASE DESCRIBE AND ALSO DEFINE I WANT TO AGENCY COLUMN VALUE WHEN COMPARE WITH FIRST+''+LAST_NAME WITH NAME COLUMN IF NAME COLUMN CONTAIN FIRST+''+LAST_NAME VALUE THEN ACCORDING TO NAME AGENCY VALUE DISPLAY IF NOT FIND THEN SHOW NA. example : name column contain LIKE davinmartyn and first+''+last+name = davinmartyn now compare with name if davinmartyn exist then agency column value display if not exist then agency column show na

Khargesh Rajput · Answer

use joining with both tables on name or select name from firsttable where name in (select (First name+last name) from secondtable)

Davin Martyn · Answer

please describe how to compare two column and find related record from different table .