Hi, 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, Stefan View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3839218#3839218 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3839218 ------------------------------------------------------- This SF.Net email is sponsored by The 2004 JavaOne(SM) Conference Learn from the experts at JavaOne(SM), Sun's Worldwide Java Developer Conference, June 28 - July 1 at the Moscone Center in San Francisco, CA REGISTER AND SAVE! http://java.sun.com/javaone/sf Priority Code NWMGYKND _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
