Could you please let me why i am getting this error ?for the below code......Msg 102, Level 15, State 1, Line 4Incorrect syntax near ','.Msg 102, Level 15, State 1, Line 11Incorrect syntax near ','.Msg 102, Level 15, State 1, Line 17Incorrect syntax near ','.SELECT cm.*FROM CRMMetrics AS cm INNER JOIN BatchRecords AS br ON cm.ApplicationJobID = br.JobNameWHERE cm.Project = 'BMongr' AND cm.Type = 'Build' AND br.TerminationUser IS NULL AND br.EndTime IS NOT NULL), BuildRootsChildrenDuration AS (SELECT br.ID AS ParentID, SUM(cm.NumSeconds) AS Duration FROM CRMMetrics AS cm INNER JOIN BuildRoots AS br ON cm.ParentID = br.ID GROUP BY br.ID), BuildRootsLeftover AS (SELECT br.ID AS ID, br.NumSeconds - cd.Duration AS LeftoverDuration, cd.Duration AS ChildrenDuration FROM BuildRootsChildrenDuration AS cd INNER JOIN BuildRoots AS br ON (cd.ParentID = br.ID)), BuildOverheads AS (SELECT cm.ApplicationID AS ApplicationID, cm.ApplicationJobID AS ApplicationJobID, 'Other' AS Type, NULL AS StartTime, LeftoverDuration AS NumSeconds FROM CRMMetrics AS cm INNER JOIN BuildRootsLeftover AS le ON cm.ID = le.ID) SELECT ApplicationID AS BuildID, ApplicationJobID AS Jobname, Type AS Action, StartTime AS StartTime, NumSeconds AS Duration FROM BuildOverheadsUNIONSELECT br.ApplicationID AS BuildID, br.ApplicationJobID AS Jobname, cm.Type AS Action, DATEADD(SECOND, cm.StartTime, '1970-01-01') AS StartTime, cm.NumSeconds AS DurationFROM CRMMetrics AS cm INNER JOIN BuildRoots AS br ON (cm.ParentID = br.ID OR cm.ID = br.ID)