To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=73627 Issue #|73627 Summary|1-to-n-joins of one table are destroyed in query desig |ner Component|Database access Version|OOo 2.0.4 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|creideiki
------- Additional comments from [EMAIL PROTECTED] Thu Jan 18 07:16:51 -0800 2007 ------- If you create a table which has a reference to itself, the query designer is quite confused: I create a table example like ID integer; name varchar; ref integer; and a query like select a.ID, a.name, b.name from example as a, example as b where a.ref = b.ID; If I open the query and switch the designer view off, I get the query SELECT "a"."ID", "a"."name", "b"."name" FROM "example" WHERE ( "a"."ref" = "b"."ID" ) The FROM statement is defect and the query must be edited before it is funktional again. --------------------------------------------------------------------- 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]
