selectfrom inner join UserGroups as ug ONp.UserGroups_ID = ug.ID p.UserGroups_ID IN (select UserGroups_ID from UsersToUserGroups whereUsers_ID = 1) p.IsDeleted = 0 p.
FROM usergroups, frontend_users WHERE usergroups.uid = SUBSTRING_INDEX(frontend_users.usergroup, ',', 1)),
(SELECT usergroups.title FROM usergroups, frontend_users WHERE usergroups.uid = SUBSTRING_INDEXFROM usergroups, front
我有一个名为A的实体,它有一个属性userGroupsPublic class A {
@JoinTable(name = "a_user_groups", ...)...我需要找到那些A实体,它们的userGroups与给定的Set<UserGroup> userGroups参数没有交集这是我的方法:
@Query("SELECT a FROM A