hi ben,
ojb buils the joins based on the foreignkey fields in the repository. there are no other fields used for joins.
hth jakob
Ben Hall schrieb:
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]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
