https://bugs.documentfoundation.org/show_bug.cgi?id=96516
--- Comment #2 from t...@tim-passingham.co.uk --- Created attachment 121480 --> https://bugs.documentfoundation.org/attachment.cgi?id=121480&action=edit Test files I attach 4 files to demonstrate this. The txt file is really a zip. odbc.ini and odbcinst.ini are from an ubuntu 14.04 system (in /etc) with unixodbc and libsqliteodbc installed. odbc.ini will need editing to point to test.sqlite. test.sqlite has two tables, t1 with an id key and text field, t2 with an id2 key, id key as a foreign key to t1, and a text field. test.odb uses odbc to access test.sqlite (I assume it will need this link resetting on installation). There is a query called test that attempts to find all entries in t1, including those that don't have entries in t2, but it cannot be done. I want a LEFT join from t1 to t2, but BASE only supports RIGHT joins, which sqlite rejects. IF I switch the tables round to use a LEFT join using BASE it fails. I can use pure SQL and a LEFT join so BASE ignores the syntax but the resulting query can't then be filtered using forms and so on, so doesn't work with an application that is being used specifically to employ such filters. Help! -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs