I think I solved the problem. I used a MySQL 4.0.15 DB. This DB does not support subqueries. MySQL 4.1.x should do it, but at this is at the moment at alpha stage. I tried it with MSSQL DB and it worked.
Does anybody know if Postgres does support subqueries? View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3838593#3838593 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3838593 ------------------------------------------------------- This SF.Net email is sponsored by the new InstallShield X. >From Windows to Linux, servers to mobile, InstallShield X is the one installation-authoring solution that does it all. Learn more and evaluate today! http://www.installshield.com/Dev2Dev/0504 _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user