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'