EJB query - subquery

code

ejb-jar.xml=>
select object(o) from UserAccount o
 where  o.ibuser.userId = ?1 and
 o.product.productCode in
 (select t.productCode from TransactionRuleProduct t
 where t.transactionRuleCode=?2
 and (t.isFromAcc =?3 or t.isToAcc=?4))


sql=>
select * from userAccount
where userid ='userxxx'
and productCode
in ( select productode from  TransactionRuleProduct
where transactionRuleCode=''
and (isFromAcc =1 or isTooAcc=1)
)