Hi Andrew,
> query1 uses a left join between two tables.
> query2 also uses a left join between two tables.
> One table is common to both queries.
>
> I now try to create a query3 that joins query1 and query2 on a common
> key. Inner join works fine but a left join generates the error "Unknown
> JDBC excape sequence: { "
>
> If I go back and change to inner join in both query1 and query2 then a
> left join in query3 runs with the expected data returned.
Sounds a little as if HSQL allows for less features in sub selects than
in outer selects (similar to the parameter problem). For my lazyness :),
do you have an example at hand?
Thanks & Ciao
Frank
--
- Frank Schönheit, Software Engineer [EMAIL PROTECTED] -
- Sun Microsystems http://www.sun.com/staroffice -
- OpenOffice.org Database http://dba.openoffice.org -
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
