OQL FROM with multiple objects

[hu...@gmx.de]

Hi!
Is it possible with OJB to use a from with multiple objects like:

select p.name, o.name from Person p, p.office o

If yes, what is the correct syntax? I tried it like written above and 
with "... from Person as p ..." but it didn't work.

Is a query with multiple and not associated objects possible?
example:

select p.name, o.name from Person p, Office o where o.address = p.address

If yes, what objects would I receive?

Thanks!
   Florian

-- 
COMPUTERBILD 15/03: Premium-e-mail-Dienste im Test
--------------------------------------------------
1. GMX TopMail - Platz 1 und Testsieger!
2. GMX ProMail - Platz 2 und Preis-Qualitätssieger!
3. Arcor - 4. web.de - 5. T-Online - 6. freenet.de - 7. daybyday - 8. e-Post


---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org