0 Replies Latest reply on Feb 15, 2005 7:17 AM by Palvinder Gharmount

    EJB-QL with 2 CMP EJB

    Palvinder Gharmount Newbie

      I want to write a customised finder method for my CMP EJB. The EJB has a one to many relationship with another bean.

      How can i write EJB-QL that will return results matching criteria in both beans..this is how i would do it in oracle....

      SELECT *
      FROM BGS.WELL_DATA A, BGS.SURF_DEPTHS B
      WHERE A.WID=B.WID
      AND A.WID=4
      AND B.SOURCE='SH'