5 Replies Latest reply on Feb 7, 2002 5:11 PM by David Jencks

    inner joing queries don't work ?

    Pawel S. Veselov Newbie

      Hi !

      I'm using Inner Joing queries to perform a cross selection
      and it shows up that the word 'inner' is appended to the
      table name.



      findByCustom
      inner join custom on custom.cid = table.id where custom.desc = {0}
      id



      The SQL engine shows up the following:

      14:31:07: Con ID: 3814691 [druid] com.pointbase.jdbc.jdbcConnection::prepareStatement( java.lang.String )( "SELECT TABLE.id FROM TABLEinner join custom on custom.cid = table.id where custom.desc = ? ORDER BY id" )

      If I insert space after the tag then of course
      it comes out as

      select TABLE.id where inner join custom.cid.....


      And that is either an error.

      Does anybody else saw that ?

      By the way, is there anyway to specify a pure complete
      query for a finder without writing only the clauses for
      it ?

      Thanks !
      Pawel.