Path expected for join!
xảy ra với đoạn query dưới đây:"SELECT e FROM UserGroupMember e " + "INNER JOIN UserGroup a ON e.userGroupId = a.id " + "INNER JOIN EzyCRMEventUserGroup b ON a.id = b.userGroupId " + "INNERJOIN EzyCRMEvent c ON b.eventId = c.id " + "INNER JOIN DataMapping d ON c.id = d.toDataId " + "INNER JOIN EzyCRMUserGroup f ON d.fromDataId = f.id " + "INNER JOIN EzyCRMEventUserGroup g ON f.id = g.userGroupId " + "WHERE e.userId IN ?1 " + "AND a.groupType = 'MATCH' " + "AND a.status = ?2 " + "AND c.eventType = 'ROUND' " + "AND d.mappingName = 'player_group_round' " + "AND f.groupType = 'AGE_GROUP' " + "AND g.eventId = ?0 " + "ORDER BY e.id DESC"
Lỗi:
Path expected for join! [SELECT e FROM org.youngmonkeys.ezycrm.entity.UserGroupMember e INNER JOIN org.youngmonkeys.ezycrm.entity.UserGroup a ON e.userGroupId = a.id INNER JOIN org.youngmonkeys.ezycrm.entity.EzyCRMEventUserGroup b ON a.id = b.userGroupId INNER JOIN org.youngmonkeys.ezycrm.entity.EzyCRMEvent c ON b.eventId = c.id INNER JOIN org.youngmonkeys.ezyplatform.entity.DataMapping d ON c.id = d.toDataId INNER JOIN EzyCRMUserGroup f ON d.fromDataId = f.id INNER JOIN org.youngmonkeys.ezycrm.entity.EzyCRMEventUserGroup g ON f.id = g.userGroupId WHERE e.userId IN ?1 AND a.groupType = 'MATCH' AND a.status = ?2 AND c.eventType = 'ROUND' AND d.mappingName = 'player_group_round' AND f.groupType = 'AGE_GROUP' AND g.eventId = ?0 ORDER BY e.id DESC]