Left joins seem to be a problem with the current build.
I have:
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.
Drew
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]