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