<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - SQL Syntax incorrect for LEFT / RIGHT JOIN when migrating from Base to Firebird" href="https://bugs.documentfoundation.org/show_bug.cgi?id=125162#c18">Comment # 18</a> on <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - SQL Syntax incorrect for LEFT / RIGHT JOIN when migrating from Base to Firebird" href="https://bugs.documentfoundation.org/show_bug.cgi?id=125162">bug 125162</a> from <a class="email" href="mailto:robert@familiegrosskopf.de" title="Robert Großkopf <robert@familiegrosskopf.de>"> Robert Großkopf</a> <pre>One hint for the problem reported in the bug: The with { oj .... } have created by the GUI and HSQLDB. When I create a query with RIGHT OUTER JOIN in the GUI with Firebird an LO 6.4.3.1 it will work well. No brackets and no "oj" ist added. Code in Firebird differs a little bit to code in HSQLDB. So I don't know if we should call this a bug. The migration tool doesn't solve any of the problems written down in the wiki. It must be solved by the user of the database.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>