I have used joins directly in the repository.xml file to specify multiple tables for one class.
Ex.
<class-descriptor class="myClass"
table="people left join usernames on usernames.person_id = people.person_id">
</class-descriptor>
It works for me.....give it a try..... --Bobby
Ben Hall wrote:
Hi,
Is it possible within OJB to specify additional criteria in (outer) joins ? If so, can anyone point me at some examples ?
I'd like to do something similar to this:
SELECT A0.NAME, A2.NAME FROM TABLE0 A0
LEFT OUTER JOIN TABLE1 A1 ON A0.TABLE1ID = A1.ID LEFT OUTER JOIN TABLE2 A2 ON A1.TABLE2ID = A2.ID AND A2.VALUE < 10
Thanks, Ben.
___________________________________________________________
HPD Software Ltd. - Helping Business Finance Business
Email terms and conditions: www.hpdsoftware.com/disclaimer
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
-- ---------------------------- Bobby Lawrence MIS Application Developer
Jefferson Lab (www.jlab.org)
Email: [EMAIL PROTECTED] Office: (757) 269-5818 Pager: (757) 584-5818 ----------------------------
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
