in the jdbc 3.0 specification The escape syntax for an outer join is: {oj <outer-join>} where <outer-join> has the form: table {LEFT|RIGHT|FULL} OUTER JOIN {table | <outer-join>} ON searchcondition
when i tested this syntax, it does'nt work with multiple outer joins. and I tested with this syntax : {oj table <outer-join>} where <outer-join> has the form: {LEFT|RIGHT|FULL} OUTER JOIN {table} ON searchcondition {<outer-join>} and it works , but this syntax is not jdbc 3.0 compliant. -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]