Index: openacs-4/packages/survey/sql/oracle/survey-package-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/survey/sql/oracle/survey-package-create.sql,v diff -u -r1.4 -r1.4.2.1 --- openacs-4/packages/survey/sql/oracle/survey-package-create.sql 10 Oct 2003 14:41:45 -0000 1.4 +++ openacs-4/packages/survey/sql/oracle/survey-package-create.sql 14 Nov 2003 17:22:40 -0000 1.4.2.1 @@ -476,7 +476,7 @@ (select max(response_id) as response_id from survey_responses group by nvl(initial_response_id, response_id)) latest - where nvl(sr.inital_response_id,sr.response_id) = o.object_id + where nvl(sr.initial_response_id,sr.response_id) = o.object_id and sr.response_id= latest.response_id; create or replace view survey_ques_responses_latest as