I have the same problem, I would like to aggregate both tables (Termination_Call_Detail and Route_Call_Detail). based on columns RouterCallKey and RouterCallKeyDay. but if you SUM() the numeric fields, they don't make sense based on Min and Max TimeStamps: Try Min and Max for: DateTime, DbDateTime, BeganRoutingDateTime or BeganCallTypeDateTime, and the sum of , TCD.Duration, , TCD.TalkTime , TCD.RingTime , TCD.DelayTime , TCD.TimeToAband , TCD.HoldTime , TCD.WorkTime , TCD.LocalQTime , TCD.NetQTime do not make any sense, they are at least twice or 10 times more than expected. I there a way to aggregate these 2 tables? (Termination_Call_Detail and Route_Call_Detail). based on columns RouterCallKey and RouterCallKeyDay?
... View more