Hi you probably mean something like 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
WHERE A2.VALUE < 10
With PersistenceBroker API this can be done using a ReportQueryByCriteria:
ex:
Criteria c1 = new Criteria();
c1.addLessThan( "<pathFromTable0ToTable1>.<pathFromTable1ToTable2>.value", new
Integer( 10 ) );
ReportQueryByCriteria query = new ReportQueryByCriteria( Table0.class, new String [] { "name",
"<pathFromTable0ToTable1>.<pathFromTable1ToTable2>.name" } );
// Then get a PersistenceBroker instance, extract values using
getReportQueryIteratorByQuery(...) and close the PersistenceBroker
bye
Danilo
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]
