Cacher is the code snippet organizer for pro developers

select  TRA.TrainingId , TRA.Trai_Name,
		TS.SessionId, TS.Sess_Name, 
		C.CourseComponentId, C.Cour_Name, MeSe_CourseComponentId,
		P.Plan_startedOn, P.plan_FinishedOn, TrSe_NewResourceId
from	cor_meetingSession ms	
		inner join Cor_TrainingSession TS
			on ms.MeSe_TraningSessionId = TS.SessionId
		inner join Stu_CourseComponent C
			on C.CourseComponentId = ms.MeSe_CourseComponentId
		inner join dbo.Cor_PlannedEvent P
			on ms.PlannedEventId = P.PlannedEventId
		inner join dbo.Cor_Training TRA
			on TS.TrSe_TrainingId = TRA.TrainingId