ojb-user

[Prev] Thread [Next]  |  [Prev] Date [Next]

How can I make OJB to create a "select" on a select statement, not on a table? Hiller, Frank RD-PT31 Tue Nov 25 11:01:31 2008

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.