<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body>
<p>
<div>
<b><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#c3">Comment # 3</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 <span class="vcard"><a class="email" href="mailto:silvain-dupertuis@bluewin.ch" title="Silvain Dupertuis <silvain-dupertuis@bluewin.ch>"> <span class="fn">Silvain Dupertuis</span></a>
</span></b>
<pre>Migrating to Firbird, transformation of queries with JOIN works well with the
graphic editor:
FROM { oj ... RIGHT OUTER JOIN …}
replaced by
FROM ( oj ... RIGHT OUTER JOIN ...)
But using the graphic query editor on such queries breaks the syntax
Either the additional table is ignored
Either the editer reconstruct the old syntax and breaks the query
So one has to use exclusively the SQL editor for queries with OUTER JOIN</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>