java集合多对多_java – JPA从具有多对多关联的集合中选择

我有2个具有多对多关联的实体类.

ModPm：

@Entity

@Table(name = "MOD_PM")

public class ModPm extends WebPageObject implements Serializable, IDBNamedEntity {

private static final long serialVersionUID = 1L;

public final static String Q_GET_WITHOUT_STATUS_FOR_SCOPE = "ModPm.getWithoutStatusForScope";

@Id

private long id;

....

@ManyToMany

@JoinTable(name = "MOD_PM_SCOPE_TYPES",

joinColumns = @JoinColumn(name = "PM_ID"),

inverseJoinColumns = @JoinColumn(name = "SCOPE_TYPE_ID")

)

private List modScopeTypes;

ModScopeType：

@Entity

@Table(name = "MOD_SCOPES")

@Cacheable

public class ModScopeType extends WebPageObject implements Serializable {

private static final long serialVersionUID = 1L;

public final static String Q_GET_ALL = "ModScopeType.getAll";

@Id

@Column(name = "ID")

private long id;

....

//bi-directional many-to-many association to ModPm

@ManyToMany

@JoinTable(name = "MOD_PM_SCOPE_TYPES",

joinColumns = @JoinColumn(name = "SCOPE_TYPE_ID"),

inverseJoinColumns = @JoinColumn(name = "PM_ID")

)

private List modPms;

是否可以从MOD_PM表中选择在MOD_PM_SCOPE_TYPES表中记录SCOPE_TYPE_ID = 1的实体？

本机SQL查询：

SELECT ID, NAME FROM MOD_PM WHERE ID IN (SELECT PM_ID FROM MOD_PM_SCOPE_TYPES WHERE SCOPE_TYPE_ID=1)

如何将此查询翻译为JPQL？