On this simple level I would consider HSQLDB as free of bugs whereas the primitive Base parser fails in many different ways. Did you try the direct SQL mode (SQL view, menu:Edit>Run SQL directly)? If you get reasonable result in direct mode, it is one of many bugs in the Base's SQL parser.
-- View this message in context: http://nabble.documentfoundation.org/SQL-statement-in-Base-query-tp3996273p3996282.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted