0 Replies Latest reply on Jul 12, 2004 4:57 AM by ghoyle

    help with a ejb-ql query for many to many relationship

    ghoyle

      Hi,

      I am having problems writing a ejb-ql query to based on a many to many relationship.
      Fairly new to entity beans etc.

      I have 2 entities: ClientDetails and the other is called TVBS
      and there is a many to many relationship between them.

      I want all of the TVBS's that a client has access too.

      the ejb-relationship between them is called client-tvbs
      The abstraact schema name for ClientDetails is cdetails
      and the abstract schema name for TVBS is atvbs

      I would be passing in a userID, which is a cmr field to search on for the ClientDetails.


      Any help with this would be most appreciated.

      Thanks

      G