[castor-dev] HOW to write a JOIN statement (OQL) that performs a join on 2 objects and maps the results into a Java object

[Sandi Ronston]

Hello everyone,   I would like to perform a JOIN on 2 tables, Employee and History.  From the results of this JOIN, I'd like Castor to map the results into a Java Class, EmployeeHistory, that is defined in the mapping.xml.   Let me say that I am able generate the 2 objects, Employee and History. Unfortunately, I can't figure out how to write an OQL statement that performs a join on these 2 objects and maps the results into a Java object.     Any help or advice would be greatly appreciated!   Sandi   Note:   Using MySql Database.