we can use inner join in asp.net .... if we join two names like Firstname and lastname as a single name

Question

Senthilkumar · Answer

Hi Selvi, You can use the query or function to join the two names in the same table or multiple table. SELECT EmployeeID, FirstName+' '+LastName AS [Employee Name] FROM Employees SELECT EmployeeID, FirstName+SPACE(2)+LastName AS [Employee Name] FROM Employees Here SPACE function is used to give the space between the string. It accepts the integer value to give the space. If your question is related to join the two names which is in the different table then yes! SELECT E.EmployeeID, E.FirstName+' '+EA.LastName AS [Full Name] FROM Employees E INNER JOIN EmployeeAdditional EA ON EA.EmployeeID = E.EmployeeID Here i have two tables. The first name is in the one table and last name in another table. Here i have used the inner join to combine two columns names.

brunda k · Answer

Please clarify is there any question or just information.

MuthuMari M · Answer

Hi, same table, SELECT (FirstName + ' ' + LastName) "Employee First & Last Name" FROM Employees ORDER BY FirstName ASC SELECT (M.FirstnameName + ' ' + a.LastName) "First & Last Name" FROM firsttable m INNER JOIN secondtable a ON m.id = a.id Pls refer this for more samples, http://www.mysqltutorial.org/mysql-join-subqueries.aspx Thanks. If this post is useful then mark it as " Accepted Answer "

we can use inner join in asp.net .... if we join two names like Firstname and lastname as a single name

Answers (3)