Sub-sub-query not working

2008-08-28 Thread Ognjen Blagojevic
Hi devs, Is it allowed to have use a "sub-sub-query" in JPQL? For instance, if I want to select publishers with last published magazines, I can use this select SELECT p, m FROM Publisher p LEFT OUTER JOIN p.magazineCollection m WHERE m.datePublished = (SELECT MAX(m3.datePubl

Re: Sub-sub-query not working

2008-08-31 Thread catalina wei
Hi, This problem is resolved in OPENJPA-708, fix checked in under trunk r690823.. Catalina Wei On Thu, Aug 28, 2008 at 7:42 AM, Ognjen Blagojevic <[EMAIL PROTECTED]>wrote: > Hi devs, > > Is it allowed to have use a "sub-sub-query" in JPQL? For instance, if I > want to select publishers with last

Re: Sub-sub-query not working

2008-09-01 Thread Ognjen Blagojevic
Hi Catalina, Thank you for your quick reaction! Regards, Ognjen catalina wei wrote: Hi, This problem is resolved in OPENJPA-708, fix checked in under trunk r690823.. Catalina Wei On Thu, Aug 28, 2008 at 7:42 AM, Ognjen Blagojevic <[EMAIL PROTECTED]>wrote: Hi devs, Is it allowed to have u