-
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)
Last edited by ljmou9; 11-21-2002 at 09:05 PM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|