You are viewing a plain text version of this content. The canonical link for it is here.

Posted to ojb-user@db.apache.org by Alexander Prozor <ap...@isd.dp.ua> on 2003/06/05 13:30:57 UTC

Nested Query, Subquery

Hello Again :),
is it possible to use nested queries in OJB OQL ?
something like :

select distinct struct (code: c.crse_code, title: c.crse_title,
(select x
from c.offers x
where x.enrollment < 20))
from courses c

or define to classes or more in From statements?
thank you.
  

-- 
Best regards,
 Alexander                          mailto:apro@isd.dp.ua

Re: Nested Query, Subquery

Posted by Jakob Braeuchi <jb...@gmx.ch>.

hi alexander,

ojb provides only limited support for sub-queries in pb-api. sorry, no 
sub-queries for oql.

jakob

Alexander Prozor wrote:

>Hello Again :),
>is it possible to use nested queries in OJB OQL ?
>something like :
>
>select distinct struct (code: c.crse_code, title: c.crse_title,
>(select x
>from c.offers x
>where x.enrollment < 20))
>from courses c
>
>or define to classes or more in From statements?
>thank you.
>  
>
>  
>