DECLARE @TABLEA TABLE(FirstID INT, SecondID INT, UserName VARCHAR(55))
DECLARE @TABLEB TABLE(FirstID INT, SecondID INT, Location VARCHAR(55))
DECLARE @TABLEC TABLE(FirstID INT, SecondID INT, Country VARCHAR(55))

INSERT @TABLEA(FirstID, SecondID, UserName)
	SELECT 111, 2, 'John' UNION ALL
	SELECT 222, 2, 'Justin'

INSERT @TABLEB(FirstID, SecondID, Location)
	SELECT 111, 2, 'Houston' UNION ALL
	SELECT 333, 2, 'Texas'

INSERT @TABLEC(FirstID, SecondID, Country)
	SELECT 111, 2, 'America' 

SELECT 
	dt1.FirstID, 
	a.SecondID, 
	a.UserName,
	b.Location, 
	c.Country
FROM 
	(
		SELECT FirstID FROM @TABLEA UNION
		SELECT FirstID FROM @TABLEB UNION
		SELECT FirstID FROM @TABLEC) dt1
	INNER JOIN (
		SELECT FirstID, SecondID FROM @TABLEA UNION
		SELECT FirstID, SecondID FROM @TABLEB UNION
		SELECT FirstID, SecondID FROM @TABLEC) dt2 ON dt1.FirstID = dt2.FirstID
	LEFT OUTER JOIN @TABLEA a ON dt1.FirstID = a.FirstID
	LEFT OUTER JOIN @TABLEB b ON dt1.FirstID = b.FirstID
		AND dt2.SecondID = b.SecondID
	LEFT OUTER JOIN @TABLEC c ON dt1.FirstID = c.FirstID
		AND dt2.SecondID = c.SecondID