db-ojb-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Tino Schöllhorn <t.schoellh...@plattform-gmbh.de>
Subject Re: How to do this in OJB
Date Mon, 19 Jun 2006 05:36:28 GMT
Hi,

I think you could do a ReportQuery where you can specify an SQL. Just 
look in the tutorials and the JavaDocs.

Tino

k jee wrote:
> Hi All,
>   
>   I need some advice on how to achieve the following with ojb.
>   
>   Select T1.FLD1,T1.FLD2, T2.FLD2,T2.FLD3,T3.FLD1,T3.FLD2,T3.FLD4 from table1 T1, table2
T2, Table3 T3,Table4 T4 where
>   (T4.key1="XYZ") and(T3.somefield in ("A","B")) and (
>   (T4.FLD3 = T1.FLD3) and (T4.FLD3 =T2.FLD3) and (T4.FLD3= T3.FLD3)).
>   
>   Thanks you in advance,
>   Krupa
>   
>   
>   
>  		
> ---------------------------------
> How low will we go? Check out Yahoo! Messenger’s low  PC-to-Phone call rates.


---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org


Mime
View raw message