OJB - Query for two table join

[Info]

Hi,

For example, I have two table A and B. Now I want a combination 
collection of some field of A and some of B:

SELECT A.xxx, A.yyy, B.zzz
FROM A
INNER JOIN B
ON A.id = B.id
I will get a colleciton as a result after open a query by using OJB, but 
how can I get the data (xxx, yyy, zzz) from a Collection?
If OJB does not support this feature, any alternetive solutions 
available right now?

Thanks,

Wallace

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]