How to implement a simple join in CMP?

[llchen]

Hi, I have the following sql statement:

SELECT * FROM table_a as a INNER JOIN table_b as b on a.id = b.key WHERE a.ownerid = '1234';

which will return a recordset contains all the columns of table_a plus all the columns of table_b. I am wondering if this can be implemented by CMP.


Louis

[aloubyansky]

In JBoss each bean is mapped to a table. So, table_a is one bean, table_b is another.
You can preload the data for beans with one query but the way you get values in the app is entirely different.

WHAT IS ACTUALLY THE PROBLEM IS?
To fetch the correct data? or fetch it with this statement?