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