查询转换-SQL到Hql

请在HQL查询下面找到：假设p_message和p_config是域对象名称，其他是映射到列的属性。

  String hqlQuery =" SELECt message  FROM     p_message  pm WHERe pm.message_id in (SELECt a.scene FROM p_config a INNER JOIN  p_rec_type b  ON a.email_id=b.email_id AND rec_type =:rectype          WHERe a.email_type=:emailTYpe)";     query = session.createQuery(hqlQuery);    query.setParameter("rectype", 2);    query.setParameter("emailTYpe", 1);