Rather than subqueries I would hope that Castor would at least support
multiple projections within the WHERE clause of the OQL query. With this
capability your query would become the following:
SELECT o FROM com.foo.domain.OrderInfo o,
com.foo.domain.OrderInfoDetail d
WHERE o.id = d.orderId AND d.status = 1
-----Original Message-----
From: Nevin Ng [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 23, 2001 6:12 AM
To: [EMAIL PROTECTED]
Subject: [castor-dev] OQL Status and Sub queries
Hi,
Sorry guys for so many questions about castor's implementation of OQL. I
wonder what is the current status for OQL-SQL translator? Does phase 4 being
completed?
I have the following OQL query which use in clause and sub queries but
cannot get any success.
SELECT o
FROM com.foo.domain.OrderInfo o
WHERE o.id IN (
SELECT d.orderId
FROM com.foo.domain.OrderInfoDetail d
WHERE d.status = 1
)
Is there anything wrong or any reference I can refer to?
Regards,
Nevin
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev
