Hello Jim, I don't remember the right bean/field names but something like this, assuming you pass in organization's id
SELECT OBJECT(gun) FROM Organization AS org, IN(org.gangsters) AS gang, IN(gang.guns) AS gun WHERE org.id=?1 As the result you'll get all guns used in the organization. alex Monday, January 13, 2003, 12:46:28 AM, you wrote: JC> Hi JC> I have a cmp situation as follows: JC> 1. organization has a collection of gangsters ; JC> 2. gangster has a collection of guns; JC> 3. gangster has no organization cmr field; JC> 4. gun has no gangster cmr field. JC> If I have an organization, how would I say get me all guns which JC> ultimately fall under this organization(i.e. all of this organization's JC> gangster's guns)? JC> Any help is much appreciated! JC> Jim ------------------------------------------------------- This SF.NET email is sponsored by: SourceForge Enterprise Edition + IBM + LinuxWorld = Something 2 See! http://www.vasoftware.com _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
