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

--_000_BA096D1AF8AE9F408CA552890F7C14010537900EB2wiems02002ceu_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

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 tab=
le?

Thanks
Frank



  ________________________________
Confidentiality note:
The information in this email and any attachment may contain confidential a=
nd proprietary information of Heidelberger Druckmaschinen AG and/or its aff=
iliates and may be privileged or otherwise protected from disclosure. If yo=
u 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 t=
he sender immediately and to delete this email and any attachment from your=
 system.

--_000_BA096D1AF8AE9F408CA552890F7C14010537900EB2wiems02002ceu_--