Yes Patric, I agree with you. People simply too good at SQL after years of using it. :) Sound like a good FAQ. I will add it. Thomas -----Original Message----- >From: Patric Bechtel [mailto:[EMAIL PROTECTED]] >Sent: Wednesday, August 01, 2001 3:01 AM >To: [EMAIL PROTECTED] >Subject: Re: [castor-dev] OQL Status and Sub queries [Viruschecked] > >On Tue, 31 Jul 2001 09:03:28 -0700, Mark Ericson wrote: > >Hello Mark, > >from time to time I'm wondering if people ever think about >OQL BEFORE asking for SQL-features inside it... >Thomas should update the FAQ with it. >You don't need this query at all. Believe me. >Just make a relation from OrderInfoDetail to OrderInfo (as >I think this is already an 1-n relationship from OrderInfo >point of view), then you can write the statement as: >SELECT d FROM com.foo.domain.OrderInfoDetail d > WHERE d.order.status=1 > >See the point? > >If you want the order objects instead of the orderdetail >objects, you could use SELECT d.order FROM [...]. > >It's simply too easy :-) > > > >>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 >> >> > > >sincerely, > >Patric Bechtel >IPCON Informationssysteme > >PGP Public Key Fingerprint: 5579 8D11 C4A4 DD84 1CC0 D2D1 112F A924 > >----------------------------------------------------------- >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
