SELECT [ECNTrainingBy].[ECNNumber] AS [ECNNumber], [ECNTrainingBy].[AcknowledgementTrainingByID] AS [AcknowledgementTrainingByID] FROM [dbo].[ECNTrainingBy] AS [ECNTrainingBy] SELECT [TrainingGroupMembers].[ID] AS [ID], [TrainingGroupMembers].[TrainingGroupID] AS [TrainingGroupID], [TrainingGroupMembers].[UserID] AS [UserID], [TrainingGroupMembers].[FullName] AS [FullName] FROM [dbo].[TrainingGroupMembers] AS [TrainingGroupMembers] SELECT [TrainingGroups].[TrainingGroupID] AS [TrainingGroupID], [TrainingGroups].[TrainingGroupName] AS [TrainingGroupName] FROM [dbo].[TrainingGroups] AS [TrainingGroups]