SELECT u FROM User u WHERE u.id = :id

class User{
@ManyToOne( optional = false, fetch=FetchType.EAGER )
    @Fetch(FetchMode.JOIN)
    private Role role;
}

class Role{
    @OneToMany( cascade = CascadeType.ALL, mappedBy = "role", fetch=FetchType.EAGER )
    @Fetch(FetchMode.JOIN)
    private List< RolePermission > permissionsList;

    @OneToMany( cascade = { CascadeType.PERSIST, CascadeType.MERGE, CascadeType.DETACH, CascadeType.REFRESH }, mappedBy = "role", fetch=FetchType.EAGER )
    private List< User > usersList;
}

class RolePermission{
    @JoinColumn( name = "PERMISSION_ID", referencedColumnName = "PERMISSION_ID", insertable = false, updatable = false )
    @ManyToOne( optional = false, fetch=FetchType.EAGER )
    @Fetch(FetchMode.JOIN)
    private Permission permission;

    @JoinColumn( name = "ROLE_ID", referencedColumnName = "ROLE_ID", insertable = false, updatable = false )
    @ManyToOne( optional = false, fetch=FetchType.EAGER )
    @Fetch(FetchMode.JOIN)
    private Role role;
}

class Permission{
    @OneToMany( cascade = { CascadeType.PERSIST, CascadeType.MERGE, CascadeType.DETACH, CascadeType.REFRESH }, mappedBy = "permission" )
    private List< RolePermission > rolePermissionList;
}

SELECT c FROM Customer c LEFT JOIN FETCH CustomerView WHERE c.id = NULL

SELECT c.* FROM CustomerView cv, Customer c WHERE c.code = cv.code AND c.id IS NULL