cornell
9/6/2013 - 1:40 PM

Component et ComponentRun

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