Component et ComponentRun
select U.User_Name, U.User_ExternalId, TraineeId,
TRA.TrainingId ,TRA.Trai_Name, TS.Sess_Name,
C.CourseComponentId, C.Cour_Name,R.CourseComponentRunId,
Trai_IsLocked
from Stu_CourseComponent C
inner join Pla_CourseComponentRun R
on R.CoRu_CourseComponentId = C.CourseComponentId
right join cat_trainee T
on R.CoRu_LmsOwner = T.TraineeId
inner join dbo.Cor_TrainingSession TS
on T.Trai_TrainingSessionId = TS.SessionId
inner join dbo.Cor_Training TRA
on TS.TrSe_TrainingId = TRA.TrainingId
inner join Dir_User U
on T.ReTr_UserId = U.UserId