Hi, you have the same problem i'am having. You need to be able to use multiple aliases on the same table in a query. Therefore you need to be able to assign 'aliases' to criteria objects (using the PB API) and so telling them to use the same alias in their respictive where-clauses. In your example, one criteria uses no alias and the other uses 'PARENT'.
Currently OJB does not support this. I myself use OJB 0.9.7 and patched it so it supports this feature. I send this path to Jakob Braeuchi so he can have a look at it and i am hoping it will be integrated in the next release. Roger Janssen iBanx B.V ************************************************************************* The information contained in this communication is confidential and is intended solely for the use of the individual or entity to whom it is addressed.You should not copy, disclose or distribute this communication without the authority of iBanx bv. iBanx bv is neither liable for the proper and complete transmission of the information has been maintained nor that the communication is free of viruses, interceptions or interference. If you are not the intended recipient of this communication please return the communication to the sender and delete and destroy all copies. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]