SELECT
ugp1.ugp_name AS "Role Name",
ugp1.UGP_DISPLAY_NAME AS "Role Display Name",
ugp1.UGP_DESCRIPTION AS "Description",
ugp1.UGP_CREATE AS "Create Date"
FROM ugp ugp1
WHERE ugp1.ugp_name not in (select ugp.ugp_name
from pol
left join pog on pog.pol_key=pol.pol_key
join ugp on ugp.ugp_key = pog.ugp_key)
;
ugp1.ugp_name AS "Role Name",
ugp1.UGP_DISPLAY_NAME AS "Role Display Name",
ugp1.UGP_DESCRIPTION AS "Description",
ugp1.UGP_CREATE AS "Create Date"
FROM ugp ugp1
WHERE ugp1.ugp_name not in (select ugp.ugp_name
from pol
left join pog on pog.pol_key=pol.pol_key
join ugp on ugp.ugp_key = pog.ugp_key)
;
No comments:
Post a Comment