Ejbql查询in in where子句

Question

我试着做这个查询:

SELECT x FROM CompteUtilisateur x, Mail m WHERE m.adresse = :param_mail AND m IN (x.listeMail)

I失败，WHERE子句生成的查询为:

where
compteutil0_.id=listemail2_.fk__compte__id 
and listemail2_.fk__mail__id=mailimpl3_.id 
and mailimpl1_.adresse=? 
and (
    mailimpl1_.id in (
        .
    )
)

我错过了什么?有可能做我想做的事吗?谢谢你的帮助:)

Answer 1

在使用子查询时，尝试MEMBER OF.

SELECT x FROM CompteUtilisateur x, Mail m WHERE m.adresse = :param_mail AND m MEMBER OF x.listeMail