SELECT        Changeset.[Changeset ID], Changeset.Changeset, Changeset.__LastUpdatedTime, Changeset.[Policy Override Comment], [Work Item Changeset].[Work Item], 
                         [Work Item].[Work Item] AS Expr1, [Work Item].Microsoft_VSTS_Common_ActivatedBy, [Work Item].Microsoft_VSTS_Common_ResolvedBy, 
                         [Work Item].Microsoft_VSTS_Common_ClosedBy, [Work Item].Microsoft_VSTS_CMMI_TaskType, [Work Item].Microsoft_VSTS_CMMI_RequirementType, 
                         [Work Item].System_WorkItemType, [Work Item].System_Title
FROM            [Work Item Changeset] LEFT OUTER JOIN
                         [Work Item] ON [Work Item Changeset].[Work Item] = [Work Item].__ID RIGHT OUTER JOIN
                         Changeset ON [Work Item Changeset].Changeset = Changeset.__ID