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 TimeS...