To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=76377 Issue #|76377 Summary|Self join gives wrong result in interpreted SQL view Component|Database access Version|OOo 2.2 Platform|All URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|regina
------- Additional comments from [EMAIL PROTECTED] Sun Apr 15 19:10:31 +0000 2007 ------- Run the queries "ReihungWhere" and "CrossJoinWhere". They should give the same result but doesn't. If you run "ReihungWhere" in native SQL the result is correct. Because issues 73627 and 76374, do not use design mode on the queries, but always use edit in SQL view. --------------------------------------------------------------------- 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]