2 Replies Latest reply on Jun 9, 2005 5:22 AM by Tang Gang

    Does Sybase DB support "left outer join" statement ?

    Tang Gang Newbie

      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 ?

        • 1. Re: Does Sybase DB support
          Andrea Delle Chiaie Newbie

          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

          • 2. Re: Does Sybase DB support
            Tang Gang Newbie

             

            "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.