To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=94803 Issue #|94803 Summary|Query may not contain two LEFT OUTER JOIN Component|Database access Version|OOO300m9 Platform|PC URL| OS/Version|All Status|NEW Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P2 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|mechtilde
------- Additional comments from [EMAIL PROTECTED] Thu Oct 9 09:24:15 +0000 2008 ------- As you can see in the attached database. There are the queries PrimaNota and PrimaNota1. In PrimaNota there is one Left Outer Join and this you can open in design view. In PrimaNota1 there are two Left Outer Join and this you can only open in SQL view. You get an error message if you want to open it in design view. In earlier version you could open also the second query PrimaNota1 in design view. The original application is a mysql db via JDBC to OOo. I only reproduce this queries to shoe the prolem. --------------------------------------------------------------------- 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]