Correlated sub-queries

[Mark Rowell <Ma...@credittrade.com>]

Hi

I have seen various posts regarding aliases in criteria and sub-queries. I
need to perform a correlated
sub-query on a set of objects and I tried using criteria aliases when
building up my queries
but OJB never seems to use them. The objects involved are stored in a single
table and looking at SQL generated by OJB it always uses an alias of A0 for
the outer query and the sub-query.

I am using the criteria.addEqualTo("<field name>", <sub query for field>) to
"join" to my subquery
but in the sub-query I need to refer to a field of the outer query (hence
correlated!); -- I 
am using RC4. I noticed while web browsing in CVS that some changes have
been made in the last
few days regarding sub-queries -- I am not allowed direct CVS access by our
corporate firewall; hence
does anyone have a code drop from CVS they can send me?

Thanks

Mark Rowell

----------------------------------------------------------------
Mark Rowell
CreditTrade

T: +44 (020) 7400 5078
M: mailto:mark.rowell@credittrade.com

CreditTrade Limited is regulated by the FSA. (c) CreditTrade 2002. All rights reserved. The information and data contained in this email is provided for the information purposes of the addressee only and should not be reproduced and/or distributed to any other person. It is provided without any warranty whatsoever and unless stated otherwise consists purely of indicative market prices and other information.

Any opinion or comments expressed or assumption made in association with the data or information provided in this email is a reflection of CreditTrades judgement at the time of compiling the data and is subject to change. CreditTrade hereby makes no representation and accepts no responsibility or liability as to the completeness or accuracy of this email.

The content of this email is not intended as an offer or solicitation for, or recommendation of, the purchase or sale of any financial instrument, or as an official confirmation of any transaction, and should not be construed as investment advice.

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