hello John, thanks for the response, and for you reference, here is the whole code:
SELECT IsNull(EventSummary.[Event Information - Event Status],'ACTIVE') AS [Event Status], ProjectOverview.[Target Event Date - Fiscal Year] AS [Fiscal Year], ProjectOverview.[Target Event Date - Fiscal Quarter] AS [Fiscal Quarter], FY$.[Fiscal Month], ProjectOverview.[Project - Project Id] AS [Project ID], ProjectOverview.[Project - Project Name] AS [Project Name], ProjectOverview.Description, isnull(MAX(ProjectOverview.[Target Event Date - Date]),'INACTIVE') AS [Target Bid Date], EventSummary.[Bidding Start Date - Date] AS [Sourcing Bid Date], EventSummary.[Event Close Date - Date] AS [Close Date], ProjectOverview.[Owner Name] AS Owner, isnull(Team$.[Commodity Team Name],'UNCLASSIFIED') AS [Commodity Team], Team$.[Commodity Family], Team$.[Commodity Code], Team$.[Commodity Description] as [Commodity Name], Team$.[Managed Type], SavingsForm.[Spend Type], ProjectOverview.[Project Type], EventSummary.[Event Information - Template Name] as [Template Type], SavingsForm.[Region - Region Id (L1)] as Region, BG$.[Business Group], SavingsForm.[Organization - Department (L1)] as [Division Name], ProjectOverview.[Execution Strategy], ProjectOverview.[Process - Process] as Process, SavingsForm.[sum(Baseline Spend)] as [Baseline Spend], SavingsForm.[Spend in Native Currency (Currency)], SavingsForm.[Spend in Native Currency (Amount)] FROM Team$ INNER JOIN SavingsForm ON Team$.[Commodity Code] = SavingsForm.[Commodity - Commodity ID] INNER JOIN BG$ ON SavingsForm.[Organization - Department (L1)] = BG$.[Division Name] RIGHT OUTER JOIN ProjectOverview LEFT OUTER JOIN FY$ ON ProjectOverview.[Target Event Date - Fiscal Month] = FY$.[Fiscal Number] LEFT OUTER JOIN EventSummary ON ProjectOverview.[Project - Project Id] = EventSummary.[Event Information - Project Id] ON SavingsForm.[Project - Project Id] = ProjectOverview.[Project - Project Id]
and an error appeared when I performed the code you have given me
Msg 8120, Level 16, State 1, Line 1 Column 'EventSummary.Event Information - Event Status' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.