2 Replies Latest reply on Apr 16, 2004 1:36 PM by Peter Ondruska

    More than one SELECT in jboss-ql

    Peter Ondruska Newbie

      I'd need a finder like this one:

      SELECT OBJECT(o) FROM log AS o WHERE o.owner.name = ?1 AND (SELECT COUNT(*) FROM log WHERE o.owner.name = ?1 AND id > o.id) < 1

      jboss-ql is defined as SELECT .. FROM ... and seems not to allow another SELECT statement in subquery. Does anybody know how could I solve this?