2 Replies Latest reply on Jun 21, 2004 6:48 AM by stscit04

    ejb-select traversing CMR collections

    stscit04 Newbie


      in my App I have 3 CMP Beans with one to
      many relations.

      A 1 --- * B 1 --- * C

      (A has multiple B which has multiple C)

      I need to get all ids of C for an instance of A. I tried
      SELECT c.id FROM A , IN (a.bs.cs) AS c WHERE a.id = ?1)
      but it wont work. Is there a way to do this in a single
      query or do I have to get all ids of all Bs for one a and then
      all ids of all Cs for B in 2 querys ?

      Thanks in advance,