Lỗi: Path expected for join!
Vì sao lỗi <code class="markdown-inline">Path expected for join!</code> xảy ra với đoạn query dưới đây:<div class="markdown-block position-relative overflow-auto source-java">
<pre>
"SELECT e FROM UserGroupMember e <span class="pl-s">"</span> +
"INNER JOIN UserGroup a ON e.userGroupId = a.id <span class="pl-s">"</span> +
"INNER JOIN EzyCRMEventUserGroup b ON a.id = b.userGroupId <span class="pl-s">"</span> +
"INNERJOIN EzyCRMEvent c ON b.eventId = c.id <span class="pl-s">"</span> +
"INNER JOIN DataMapping d ON c.id = d.toDataId <span class="pl-s">"</span> +
"INNER JOIN EzyCRMUserGroup f ON d.fromDataId = f.id <span class="pl-s">"</span> +
"INNER JOIN EzyCRMEventUserGroup g ON f.id = g.userGroupId <span class="pl-s">"</span> +
"WHERE e.userId IN ?1 <span class="pl-s">"</span> +
"AND a.groupType = <span class="pl-s">'MATCH'</span> <span class="pl-s">"</span> +
"AND a.status = ?2 <span class="pl-s">"</span> +
"AND c.eventType = <span class="pl-s">'ROUND'</span> <span class="pl-s">"</span> +
"AND d.mappingName = <span class="pl-s">'player_group_round'</span> <span class="pl-s">"</span> +
"AND f.groupType = <span class="pl-s">'AGE_GROUP'</span> <span class="pl-s">"</span> +
"AND g.eventId = ?0 <span class="pl-s">"</span> +
"ORDER BY e.id DESC"
</pre>
</div><p>
Lỗi:
</p>
<div class="markdown-block position-relative overflow-auto source-java">
<pre>
Path expected <span class="pl-k">for</span> 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 = <span class="pl-s">'MATCH'</span> AND a.status = ?2 AND c.eventType = <span class="pl-s">'ROUND'</span> AND d.mappingName = <span class="pl-s">'player_group_round'</span> AND f.groupType = <span class="pl-s">'AGE_GROUP'</span> AND g.eventId = ?0 ORDER BY e.id DESC]
</pre>
</div>
