To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=107767 Issue #|107767 Summary|left/right join in designer returns an error Component|Database access Version|OOO320m7 Platform|Unknown URL| OS/Version|Windows 7 Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|lucianpricop
------- Additional comments from lucianpri...@openoffice.org Fri Dec 18 12:25:44 +0000 2009 ------- I have JDBC connection to a PostgreSQL database using org.postgresql.Driver. On this database I want to left/right join 2 tables using the designer to build the query: I add the two tables to the work area, drag the column from the first over the column of the other to create a join, then right click on the connecting line, click on edit and choose instead of the default type "inner join", "left join". When I try to run the query I get: SQL Status: 42601 ERROR: syntax error at or near "{" Position: 75 The query in the sql editor looks like: SELECT "table1"."bla", "table2"."blabla" FROM { OJ "public"."table2" AS "table2" LEFT OUTER JOIN "public"."table1" AS "table1" ON "table2"."refid" = "table1"."refid" } Which of course is incorrect syntax. Correcting the query make is work: SELECT "table1"."bla", "table2"."blabla" FROM ( "public"."table2" AS "table2" LEFT OUTER JOIN "public"."table1" AS "table1" ON "table2"."refid" = "table1"."refid" ) --------------------------------------------------------------------- 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: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org