https://bugs.documentfoundation.org/show_bug.cgi?id=96516
[email protected] changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] OS|Linux (All) |All --- Comment #1 from [email protected] --- To try and check that this isn't me being daft I installed everything on Windows 7 (64 bit). Same problem. sqlite3 only allows LEFT joints. BASE only allows RIGHT joins via ODBC to sqlite. BASE does support LEFT joins on mysql (native and JDBC) - I use them for another database. This is not, unfortunately, a case where I can simply reverse the table order and use the other JOIN. It is fundamental syntax mismatch. Whilst any RIGHT JOIN can be converted to a LEFT JOIN by reversing the table order, or vice-versa, the syntax incompatibility prevents this. I have to use LEFT JOIN because that's the only one sqlite supports, but BASE will not support this syntax. I get the impression that someone knew sqlite only supported one of the directional JOINs, but restricted BASE to use the wrong one. I may, of course, be completely wrong. This problem is a real pain. Constructing SQL statements to get round this is possible (it took me a while, but I found a way for single columns), but when it involves many columns it gets really complicated. If posting an example would help I will, but I can post all the odbc stuff. One doesn't need more that two tables in the BASE database. The more onerous bit is to install sqlite3, odbc, and configure it all. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
