ITCanopy

SELECT u.LOGIN as "User ID" ,res.NAME as "Responsibility" FROM S_USER u left join S_PER_RESP ri on ri.PER_ID = u.ROW_ID left join S_RESP res on res.ROW_ID = ri.RESP_ID WHERE  u.LOGIN IN (' USER.NAME ') ORDER BY u.LOGIN