Can a CMP retrive records from multiple tables using OR(Object Relational) mapping.If yes please let me know how?
If you are refering to using one CMP bean for multiple tables, it is unfortunately a vendor specific OR mapping. I am aware of BEA, but I am sure that others have as well.
Using Container Managed Relationships is the way to go for multi-table access.
MALKI SYSTEMS INC.
1. As a general rule of thumb, use BMP.
2. You may use a O/R mapping tool like TopLink too.
Using a database view might help..