hibernate - Ejbql query with in in where clause -
i try query :
select x compteutilisateur x, mail m m.adresse = :param_mail , m in (x.listemail)
i fails, query generated clause :
where compteutil0_.id=listemail2_.fk__compte__id , listemail2_.fk__mail__id=mailimpl3_.id , mailimpl1_.adresse=? , ( mailimpl1_.id in ( . ) )
what missing ? possible whant ? :)
in using sub query, try member of.
select x compteutilisateur x, mail m m.adresse = :param_mail , m member of x.listemail
Comments
Post a Comment