List Reponsibilities for an user

最新推荐文章于 2023-03-11 20:16:51 发布

最新推荐文章于 2023-03-11 20:16:51 发布 · 126 阅读

本文深入解析了一条SQL查询语句，包括其结构、用途及如何实现特定数据筛选和排序功能。通过实例展示如何使用JOIN、ORDER BY等关键字，实现复杂的数据操作。

SELECT fu.user_name,frt.RESPONSIBILITY_NAME, fu.user_id,furg.responsibility_id
FROM
fnd_user_resp_groups furg,
FND_RESPONSIBILITY fr,
fnd_responsibility_tl frt,
fnd_user fu
WHERE fu.user_name =upper('ptian')
AND   fu.user_id = furg.user_id
AND   furg.responsibility_id = fr.RESPONSIBILITY_ID
AND   frt.responsibility_id = fr.RESPONSIBILITY_ID
ORDER BY 1