HSQL-related question

[Cloey Tan]

Im working on some hsql dynamic generation. Since Im not that familiar with the hsql query, would like to seek some help here regarding this particular case. Assuming that
I have a User entity, and related to Role Entity.

public class User{
protected List<Role> roles;
}

is it relevant to put >> select user from User as user AND user.roles as userRole WHERE userRole.name='super'
in order to select all users with the role name 'super'??

[Rob Spoor]

Moving to JDBC