delete from usr_role where usr_id= AND role_id= select x.usr_id ,x.role_id ,p.role from usr_role x join role p on (x.role_id=p.role_id) where x.usr_id= order by 2 Роли пользователя (#qRead.recordCount#):
Роль
#role#
select c.role_id, c.role from role c order by c.role />