Join two tables and return all rows and columns in SQL Server

Hi IamAzhar,

Refer below Query.

SQL

DECLARE @Table1 AS TABLE (ID INT,[Column-1] VARCHAR(10))
INSERT INTO @Table1 VALUES(1,'AAA')
INSERT INTO @Table1 VALUES(2,'BBB')

DECLARE @Table2 AS TABLE (ID INT,[Column-1] VARCHAR(10),[Column-2] INT)
INSERT INTO @Table2 VALUES(1,'CCC',0)
INSERT INTO @Table2 VALUES(2,'DDD',0)
INSERT INTO @Table2 VALUES(3,'EEE',0)

;WITH CTE AS (
	SELECT ID AS [Row],[Column-1],NULL AS 'Column1',NULL AS 'Column-2' FROM @Table1
	UNION
	SELECT ID,NULL,[Column-1],[Column-2] FROM @Table2
)
SELECT ROW_NUMBER() OVER (ORDER BY ([Row])) Id
	   ,[Column-1]
	   ,[Column1]
	   ,[Column-2] 
FROM CTE
ORDER BY [Row],Column1

Output