Changes from 5.01 to 5.02?

Folks, We recently changed from OnLine 5.01.UD(3?) to 5.02.UC6 and one of my sites has a report of different behavior in handling an SQL statement. This statement returned multiple rows under 5.01 and only one row in 5.02UC6: SELECT shift_number, op_name, oper_number, count(*), sum(total_items), job_number, xpt_number, sum(xpt_oper.end_date - xpt_oper.start_date) FROM xpt_oper, operator where oper_number = op_id group by shift_number, oper_number, op_name, xpt_number, job_number ORDER BY oper_number, xpt_number, job_number My developer said that the query worked as befor when he changed it (under 5.02.UC6) to: SELECT shift_number, op_name, oper_number, count(*), sum(total_items), job_number, xpt_number, sum(xpt_oper.end_date - xpt_oper.start_date) FROM xpt_oper, operator where oper_number = op_id group by oper_number ORDER BY oper_number, xpt_number, job_number The only difference is in the group by. Does anyone have any possible ideas why this should be different? (I'm investigating now the obvious... that something **else** has changed....you know developers :) ) Thanks Joe -- --------------------------------------------------------------------------- Joe Lumbley Dallas, Texas Hi, y'all Watch for my INFORMIX DBA Survival Guide from Prentice-Hall/Informix Press ISBN 0-13-124314-4 (12431-3) Due in bookstores October 28, 1994 orders: orders@prenhall.com (515) 284-6761 fax (515) 284-2607 ----------------------------------------------------------------------------