Does Sybase DB support "left outer join" statement ?

[tgprivate]

In jbosscmp-jdbc.xml I added a <left-join> tag to a query, and
the generated sql statement includes "left outer join".This sql statement can be excecuted in ms-sqlserver,but not in sybase db.
My question is:
How to use jboss's <left-join> tag to generate query that sybase db can understand ?

[adellechiaie]

Which version of Sybase ASE (I suppose) are you using???
Until ASE 11.9.2 only TransactSQL left outer join syntax is supported (t1*=t2), from 12.0 and after (12.5.x) also the ANSI syntax is supported (left outer join t1 on t2.id=t1.id).
Ciao

[tgprivate]

"adellechiaie" wrote:
Which version of Sybase ASE (I suppose) are you using???
Until ASE 11.9.2 only TransactSQL left outer join syntax is supported (t1*=t2), from 12.0 and after (12.5.x) also the ANSI syntax is supported (left outer join t1 on t2.id=t1.id).
Ciao

Thank you very much!

We are using ASE 11.9.2.