在HQL查询中从依赖实体中选择属性

Question

我有以下实体：

@Entity
class A {
   @Id
   @GeneratedValue(generator = "system-uuid")
   @GenericGenerator(name = "system-uuid", strategy = "uuid2")
   String id;
        //some field        

   @ManyToMany
   Set<B> other;
}

@Entity
class B {
    @Id
    @GeneratedValue(generator = "system-uuid")
    @GenericGenerator(name = "system-uuid", strategy = "uuid2")
    String id;
    //some field
}

我想为包含在Set中的A实体创建hql查询B的哪个列表id

类似（不正确）的内容：

select a.other.id from A as a where a.id = :pid




Answer 1

尝试以下操作：

select a.other.id from A a join a.other o where a.id = :pid