I have attached an example document that shows of an output I would like to see.
Here is the query that I've been trying to use. Is this where grouping can come in handy
or any other statements that can be used.
SELECT act.act_first_name || ' ' || acr1.act_last_name "Actor",
arg.arg_rgp_code "Rights Group",
FROM v_act_actor act
LEFT JOIN v_acr_actor_role_1 acr1 ON act.act_id = acr1.acr_act_id
LEFT JOIN v_arg_act_rightgroup arg ON act.act_id = arg.arg_act_id
WHERE act.act_status = 'A'
AND act.act_manager_code = '49364'