Index: openacs-4/packages/survey/www/admin/responses-export-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/survey/www/admin/responses-export-oracle.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/survey/www/admin/responses-export-oracle.xql	23 Nov 2002 05:18:16 -0000	1.2
+++ openacs-4/packages/survey/www/admin/responses-export-oracle.xql	16 Jan 2003 14:04:53 -0000	1.3
@@ -61,7 +61,8 @@
           r.creation_date,
           q.abstract_data_type,
           q.sort_order
-     from survey_questions q, (select initial_user_id as user_id, creation_date, response_id from survey_responses_latest rt where survey_id=:survey_id) r, cc_users u, survey_sections ss
+     from survey_questions q, (select initial_user_id as user_id, creation_date, response_id from survey_responses_latest rt where survey_id=:survey_id) r, (select p.email, u.first_names, u.last_name, u.person_id as user_id from parties
+p, persons u where p.party_id=u.person_id) u, survey_sections ss
      where ss.survey_id=:survey_id
      and q.section_id=ss.section_id
      and r.user_id = u.user_id) sq