Hi,
There is no relationship but now I found the solution. This is the example I followed:
SELECT t1.FirstName1, t1.LastName1, t2.FirstName2, t2.LastName2
FROM
(SELECT
FirstName1,
LastName1,
ROW_NUMBER() OVER (ORDER BY FirstName1) 'RowNumber'
FROM table1
) AS t1
FULL OUTER JOIN
(SELECT
FirstName2,
LastName2,
ROW_NUMBER() OVER (ORDER BY FirstName2) 'RowNumber'
FROM table2
) AS t2
ON t1.RowNumber = t2.RowNumber
Sorry. I am looking at this a bit different. Are you wanting to display the results in the same query return? Or, would you like to display the information side by side in SSMS?
When you have two tabs open in ssms. Right click a tab and the below options appear. If this does not help, sorry about that! I thought it was cool though!