如何将嵌套的SQL转换为HQL

String update = "update Patient p set p.last_name = :new_last, p.first_name = :new_first where p.id = some (select doctor.id from Doctor doctor where doctor.clinic_id = 22 and city = 'abc_city')";

如果您检查规范，则可以算出如何用语表达hql查询。您可以在此处找到有关子查询的部分。