I'm trying to produce a report that shows contracts that are related to a project, but the following query produces a duplicate result:
START WITH Project SELECT Id, Code, Name, Projects.Left.Code, Projects.RelationshipType.LeftName WHERE Code LIKE @Code ORDER BY Code