Join two tables without any condition only on row by row basis

For suppose EmployeeFirstName and EmployeeLastName tables are like below:

 
SELECT * FROM EMPLOYEEFIRSTNAME
SELECT * FROM EMPLOYEELASTNAME

There is no direct way to join these two tables because there is no common column to establish the relationship. Then, create two temporary tables with identity rownumber column, based on this write the inner join query as follows.

 
CREATE TABLE #FNAME(FName NVARCHAR(100),ROWNUMBER INT NOT NULL IDENTITY (1, 1))
CREATE TABLE #LNAME(LName NVARCHAR(100),ROWNUMBER INT NOT NULL IDENTITY (1, 1))
INSERT INTO #FNAME(FName)
SELECT FName FROM EMPLOYEEFIRSTNAME
INSERT INTO #LNAME(LName)
SELECT LName FROM EMPLOYEELASTNAME
SELECT FN.FName+' '+LN.LName AS FullName FROM #FNAME FN 
INNER JOIN #LNAME LN ON FN.ROWNUMBER = LN.ROWNUMBER