Reported By: Clive Bennett Reported On: 3/20/2004 For: Version 4.05 Build 1
# 1619SQL SELECT Statement GROUP BY Clause Not Working Properly Without an ORDER BY The following query used to group correctly in V4.04 In the new V4.05, the grouping does not occur unless I add an ORDER BY
Clause.
select
4,period,'Depreciation',sum(dep_int_amt),project_code
from
rpt_balance_sheet_variable_items
where
dep_or_int_flag = 'D'
group by
period,project_code
Comments and WorkaroundsAdding an ORDER BY clause that exactly matches the GROUP BY clause fixes the problem.
ResolutionFixed Problem on 3/20/2004 in version 4.06 build 1