[LMS].[Curriculum]
	[CurriculumKey] [int] IDENTITY(1,1) NOT NULL,
	[CurriculumName] [varchar](255) NOT NULL,
	[CustomerServiceCourse] [bit] NULL,
	[FranchiseCourse] [bit] NULL,
	[ManagerCourse] [bit] NULL,
	[CurriculumType] [varchar](25) NULL

[LMS].[UserCurriculum]
	[Username] [varchar](255) NOT NULL,
	[CurriculumKey] [int] NOT NULL,
	[CompletionDateKey] [int] NOT NULL,
	[FranchiseKey] [int] NOT NULL

SELECT c.*,
   uc.*
FROM LMS.Curriculum c
   LEFT OUTER JOIN LMS.UserCurriculum uc ON c.CurriculumKey = uc.CurriculumKey
ORDER BY CompletionDateKey;

SELECT c.*,
   uc.*
FROM LMS.Curriculum c
   RIGHT OUTER JOIN LMS.UserCurriculum uc ON c.CurriculumKey = uc.CurriculumKey
ORDER BY CompletionDateKey;

SELECT c.*,
   uc.*
FROM LMS.Curriculum c
   FULL OUTER JOIN LMS.UserCurriculum uc ON c.CurriculumKey = uc.CurriculumKey
ORDER BY CompletionDateKey;

;WITH CTE_Users (Username)
AS
(
 SELECT DISTINCT Username
 FROM LMS.UserCurriculum
)
SELECT c.*,
   u.*,
   uc.*
FROM LMS.Curriculum c
   CROSS JOIN CTE_Users u
   LEFT JOIN LMS.UserCurriculum uc ON uc.Username = u.Username AND uc.CurriculumKey = c.CurriculumKey
WHERE u.Username = 'TestUser' AND uc.Username IS NULL
ORDER BY u.Username, c.CurriculumKey;

select uc.UserName, uc.CurriculumKey  -- Select the user's...
from UserCurriculum uc
where exists (	                                                                     -- ...where you can't find a missing Curriculum
	select *
	from Curriculum c1
	left outer join
		UserCurriculum uc1
			on	c1.CurriculumKey = uc1.CurriculumKey
			and uc.UserName = uc1.Username
	where
		uc1.CurriculumKey is Null
	)