users@glassfish.java.net

multiple selects in ejb ql

From: <glassfish_at_javadesktop.org>
Date: Mon, 20 Apr 2009 08:02:07 PDT

Hello,

could somebody show me some examples of joined selects in EJB QL?
I was expected that some equivalents of SQL will work, but these didn't. Here are my examples. Of course, that everything could be done much simpler, I just wanted to test it:

select item1 from Item item1, in (select item from Item item where item.id<10)
select item1 from (select item from Item where item.id<10)

Above example didn't work.
Thanks in advance,
Marian
[Message sent by forum member 'mirozet' (mirozet)]

http://forums.java.net/jive/thread.jspa?messageID=342772