Results 1 to 2 of 2

Thread: How to concutinate first_name and last_name

  1. #1
    Join Date
    Oct 2002
    Location
    queens
    Posts
    139

    Post 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.

  2. #2
    Join Date
    Sep 2002
    Posts
    6
    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
  •