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/05/28 10:12:39 UTC

Re[2]: ODMG OQL

Hello Mahler,
Please help me with this problem.
if it's possible, of course.

can I use Nested Queries in this OQL implementation?
something like this:

SELECT struct {name: S.name,courses:
        ( SELECT E
          FROM S.enrolled E
          WHERE E.Department=“CS”
        )
}
FROM StudentExt S
Or, on SQL
1. select * from users, products where users.id = products.createby and
users.name = "Alex";

2. select * from products where products.createby =
(select user.id from users where user.id='Alex');


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