 | | | escape syntax for outer join is not jdbc 3.0 compliant | escape syntax for outer join is not jdbc 3.0 compliant 2007-05-16 - By wael
Back
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/maxdb?unsub=mysql@(protected)
|
|
|