CREATE TABLE TMP (
 NAME CHAR(1)
 , AGE INT
)
GO

INSERT INTO TMP
 SELECT 'A', 60 UNION ALL
 SELECT 'B', 30 UNION ALL
 SELECT 'D', 20
GO
SELECT * FROM TMP
GO
--RESULT
--NAME AGE
------ -----------
--A    60
--B    30
--D    20
--
--(3 row(s) affected)

SELECT
 A.NAME
 , B.AGE
FROM
 (SELECT [NAME] = 'A' UNION ALL
 SELECT [NAME] = 'B' UNION ALL
 SELECT [NAME] = 'C' UNION ALL
 SELECT [NAME] = 'D' UNION ALL
 SELECT [NAME] = 'E'
 ) A
LEFT OUTER JOIN
 TMP B
 ON A.NAME = B.NAME

--RESULT 
--NAME AGE
------ -----------
--A    60
--B    30
--C    NULL
--D    20
--E    NULL