now, I need to do a subquery like this:
SELECT OBJECT(a) FROM SelectedRecs a WHERE a.sID2 IN (SELECT b.SID2 FROM SessionView b WHERE (b.LocalIP='184.108.40.206' AND b.RmtIP='220.127.116.11') OR (b.LocalIP='18.104.22.168' AND b.RmtIP='22.214.171.124'))
note that: SessionView is another table. now I just write an entitybean for table SelectedRecs, not for it.
when I run the demo using the EJB-QL above, it met some problems.
so I wanna know how to do a subquery in JBoss, and the subquery is from another table. please give me a suggestion, thanks a lot.
my msn is: qixiangnj AT gmail DOT com.
since ejbql works only on entities, there is no way you can do this in QL.
maybe it works with the <declared-sql> override in jboss-cmp-jdbc.
else you will have to use a view instead of your table, or build the other entity as well in jboss.