Assume the following HQL:

The generated SQL will be:

The association join is rendered before the entity join which results in an error. The order of joins should be retained to make this work.