posted 8 years ago
Hi,
Don't know whether I'm in the right place but here goes.
I am trying to use Libreoffice Base - Which., I understand, uses HSQLDB.
I'm trying to input a correlated subquery as so: ( I split the actual command here for clarity, appears as one line on command line)
I keep getting syntax errors: SQL Status: HY000
Error code: 1000
syntax error, unexpected $end, expecting BETWEEN or IN or SQL_TOKEN_LIKE
Any idea how to fix this would be appreciated.
R