To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=78577 Issue #|78577 Summary|Query breaks that references a subquery more than once Component|Database access Version|OOo 2.2 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|aexl
------- Additional comments from [EMAIL PROTECTED] Sun Jun 17 14:56:26 +0000 2007 ------- see attached file: main table has 2 fields that reference the same other table. creating a query with one reference works. extending the query so that it contains the second reference works too at first. after closing this query an attempt to edit it gives "column id unknown", query opens only in SQL. --------------------------------------------------------------------- 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] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]