To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=62900
------- Additional comments from [EMAIL PROTECTED] Tue Mar 7 14:53:38 -0800 2006 ------- Here is SQL query: SELECT "Enroll"."Location", "Person"."First Name", "Person"."Last Name", "Person"."ID Number B" AS "ID B", "Enroll"."Date" AS "Arrival", "Enroll"."Discharge Date" AS "Discharge", "Person"."Relationship to Household Contact Person" AS "Relationship" FROM "Person" "Person", "Enroll" "Enroll" WHERE ( "Person"."ID" = "Enroll"."Person" ) AND ( ( "Enroll"."Status" = 'Approved' AND "Enroll"."Discharge Type" = 'Future Scheduled' ) ) ORDER BY "Enroll"."Location" ASC --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
