How to concutinate first_name and last_name

Hello Everyone,

I need some help. I have a table which contains last name and first name as two different fields. I have another table which has the full name and I have to compare these name in two tables. I need to put first name + last name together in the first table and compare with the name in the second table. How would I do that?

Please help, Thanks.

Try this:

-- Find the same name from two tables

SELECT Tb1.ID, (Tb1.FirstName + ' ' + Tb1.LastName) AS Name1, Tb2.name as Name2, Tb2.ID
FROM Tb1 JOIN Tb2
ON ( (Tb1.FirstName + ' ' + Tb1.LastName) = Tb2.Name)