No idea why but I am running a query and I am getting the wrong results:
SELECT TOffice.OfficeName, TRevisionType.TypeName, TProjectManager.PlannerForename AS PMForename, TProjectManager.PlannerSurname AS PMSurname, TRevisionDetail.NoPhases, TRevisionDetail.Phase1Deploy...