0 Replies Latest reply on Apr 23, 2002 5:14 AM by curro

    Join Correct but.....???

    curro

      Hi and thanks for your atention.
      I have to beans, and i have one finder join the two tables, mi question is if i can use attributes of the bean that i join but only to find.

      This example is in the home interface in Registeredpersonbean, and of course in jaws.xml.

      If i can not do it please, can you tell me another way??

      Thanks..

      Here is my example


      <ejb-name>RegisteredPersonAccountBean

      findByAdvancedrp
      ,ArztAccountBean
      WHERE( (ArztAccountBean.login=RegisteredPersonAccountBean.login) AND
      (vorname like "%"{0}"%") AND
      (nachname like "%"{1}"%") AND
      (ArztAccountbean.city like "%"{2}"%")
      )

      vorname DESC
      <read-ahead>true</read-ahead>



      Thanks