Code:
SELECT [02 Current Remedy Data].[Assigned Individual], [02 Current Remedy Data].[Assigned Group], [02 Current Remedy Data].[Ticket ID], [02 Current Remedy Data].[Change-Id], [02 Current Remedy Data].[Arrival Time], [02 Current Remedy Data].[Ind Negotiated Date], [02 Current Remedy Data].Summary, [02 Current Remedy Data].Status, [02 Current Remedy Data].[Full Name], [02 Current Remedy Data].[Current Site], [02 Current Remedy Data].[External Reference], [02 Current Remedy Data].[Submitter Group], [02 Current Remedy Data].Keyword, [02 Current Remedy Data].Category, [02 Current Remedy Data].Source, [02 Current Remedy Data].Subcode, [02 Current Remedy Data].Priority, [02 Current Remedy Data].[Case Type], [02 Current Remedy Data].[Resolved Time], [02 Current Remedy Data].[Last Updated], [02 Current Remedy Data].CLID, [02 Current Remedy Data].Component, [02 Current Remedy Data].Country, [02 Current Remedy Data].[Is this a Parent?], [02 Current Remedy Data].[Is this a child?], [02 Current Remedy Data].[Missed SLA Reason], [02 Current Remedy Data].Reactivated, [02 Current Remedy Data].ReactivateCount, [02 Current Remedy Data].[Root Cause], [02 Current Remedy Data].[Group Count], [02 Current Remedy Data].[Assignee Count], [02 Current Remedy Data].[Met Initial Response Date?], [02 Current Remedy Data].[No of Client Chase], [02 Current Remedy Data].[EL1?], [02 Current Remedy Data].[EL2?], [02 Current Remedy Data].[EL3?], REF_MarketCountry.Country2, REF_BusinessType.BusinessType, REF_HighStatus.HighStatus, REF_RAGroup.Group2, Year([Arrival Time]) AS [Arrival Year], Month([Arrival Time]) AS [Arrival Month], Year([Resolved Time]) AS [Resolved Year], Month([Resolved Time]) AS [Resolved Month]
FROM ((([02 Current Remedy Data] LEFT JOIN REF_MarketCountry ON [02 Current Remedy Data].[Current Site] = REF_MarketCountry.[Current Site]) LEFT JOIN REF_BusinessType ON [02 Current Remedy Data].Subcode = REF_BusinessType.SubCode) LEFT JOIN REF_HighStatus ON [02 Current Remedy Data].Status = REF_HighStatus.Status) LEFT JOIN REF_RAGroup ON [02 Current Remedy Data].[Assigned Group] = REF_RAGroup.RA;