report on user account details - Role Names
Summary
SQL for reporting on employees rolesContent
Can someone see how to stop the multiple rows from returning in below SQL?
select "PER_USERS"."USERNAME" as "USERNAME",
"PER_ROLES_DN_VL"."ROLE_NAME" as "ROLE_NAME",
"PER_ALL_PEOPLE_F"."ATTRIBUTE3" as "ATTRIBUTE3",
"PER_PERSON_NAMES_F"."FIRST_NAME" as "FIRST_NAME",
"PER_PERSON_NAMES_F"."LAST_NAME" as "LAST_NAME",
"PER_ALL_PEOPLE_F"."EFFECTIVE_START_DATE" as "EFFECTIVE_START_DATE",
"PER_ALL_PEOPLE_F"."EFFECTIVE_END_DATE" as "EFFECTIVE_END_DATE"
from "FUSION"."PER_PERSON_NAMES_F" "PER_PERSON_NAMES_F",
"FUSION"."PER_ALL_PEOPLE_F" "PER_ALL_PEOPLE_F",
Tagged:
1