Hi,
try (cannot test if works):
<declared-sql>
o
WHERE o.status = {0} AND o.CPTransactionId = ( SELECT
MIN(o1.CPTransactionId) FROM CPRecoverLog o1 WHERE o1.status = {0})
</declared-sql>
But do you relly need a subquery ?
Hope this helps
View the original post :
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3876024#3876024
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3876024
-------------------------------------------------------
This SF.Net email is sponsored by: NEC IT Guy Games.
Get your fingers limbered up and give it your best shot. 4 great events, 4
opportunities to win big! Highest score wins.NEC IT Guy Games. Play to
win an NEC 61 plasma display. Visit http://www.necitguy.com/?r=20
_______________________________________________
JBoss-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/jboss-user
