HQL for two tables linked by a relationship table?

[Stuart Rogers]

Given the really stripped-down essence of two classes

@Table( name="districts")
class District {
    @id
    Long id;
    String name;

    @OneToMany(fetch = FetchType.LAZY)
    @JoinTable(name="school_district_relationship",
            joinColumns={ @JoinColumn(name="id_district") },
            inverseJoinColumns={ @JoinColumn(name="id_school") }
    )
    private Set<School> schools;

}

and

@Table( name="schools")
class School {
    @id
    Long id;
    String name;

    @ManyToOne(fetch = FetchType.LAZY)
    @JoinTable(name="school_district_relationship",
            joinColumns={ @JoinColumn(name="id_school") },
            inverseJoinColumns={ @JoinColumn(name="id_district") }
    )
    private District district;

}

and that the relationship table does get filled in with the district-school id mappings,

how would I write the following straight-SQL query
" select aa.name, bb.name FROM districts AS aa
JOIN school_district_relationship AS rr
ON aa.id = rr.id_district
JOIN schools AS bb
ON bb.id = rr.id_school
ORDER BY 1,2
;

in Hibernate's HQL? Nothing I've tried in HQL works except for the simplest " FROM Districts" Trying

Query hqlQuery = " aa.name, bb.name FROM District AS aa JOIN School AS bb ORDER BY 1,2 "  just hangs.

I need an HQL query that will generate:
name | name
=================
ALAMEDA | KENNEDY
ALAMEDA | SHRIRE
FREEMONT | TOBIAS
FREEMONT | UNDERWOOD
FREEMONT | WATERFORD

Any hints/suggestions/constructive critisms and especially examples are always greatly appreciated!

TIA,

Still-learning Stuart