How can I make OJB to create a "select" on a select statement, not on a table?

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

How can I make OJB to create a "select" on a select statement, not on a table?

Hiller, Frank RD-PT31
Hi,

I'm using "ReportQueryByCriteria" of the PB API in OJB 1.0.3.

What I'm trying to do is to create a statement like this:
SELECT columnA, columnB, columnC FROM ( select ... from tableName where ...)

OJB always creates a statement like this:
SELECT A0.columnA, A0.columnB, A0.columnC FROM tableName A0 WHERE ...

How can I make OJB to create a "select" on a select statement, not on a table?

Thanks
Frank



  ________________________________
Confidentiality note:
The information in this email and any attachment may contain confidential and proprietary information of Heidelberger Druckmaschinen AG and/or its affiliates and may be privileged or otherwise protected from disclosure. If you are not the intended recipient, you are hereby notified that any review, reliance or distribution by others or forwarding without express permission is strictly prohibited and may cause liability. In case you have received this message due to an error in transmission, we kindly ask you to notify the sender immediately and to delete this email and any attachment from your system.
Loading...