I have following EntityBean in my applicaiton
1. AccountBean : For Account stores in System
2. PartyBean: Client Available in System
3. ProductBean: Product offered by System

Account can be associated to a party and party internallu use account for specific products.
Now I have a requirment where I have to show all acount for a specific customer which he is using for a specific product. How should I go about these?
I mean should a join the tables manually or use CMP for this?

Note that System can have huge no of rows for Account and Party.

any input on this is higly appreciated.

Best Regards,