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