Hi, I am having problems writing a ejb-ql query to based on a many to many relationship.
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 clientdetails and the abstract schema name for TVBS is tvbs I would be passing in a userID to search on for the ClientDetails. JBOSS does create the tables and a intermediatry table to resolve the many to many. Any help with this would be most appreciated. Thanks G View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3841375#3841375 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3841375 ------------------------------------------------------- This SF.Net email sponsored by Black Hat Briefings & Training. Attend Black Hat Briefings & Training, Las Vegas July 24-29 - digital self defense, top technical experts, no vendor pitches, unmatched networking opportunities. Visit www.blackhat.com _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user