/* Formatted on 7/18/2014 9:39:03 AM (QP5 v5.115.810.9015) */
SELECT orig_system,
description,
orig_system_id,
name "Login Name",
display_name "Employee Name"
FROM wf_local_roles wfr1
WHERE (wfr1.orig_system <> 'WF_LOCAL_ROLES' AND wfr1.orig_system_id <> 0)
AND EXISTS
(SELECT 'row found'
FROM wf_local_roles wfr2
WHERE (wfr2.orig_system <> 'WF_LOCAL_ROLES'
AND wfr2.orig_system_id <> 0)
AND wfr2.orig_system_id = wfr1.orig_system_id
AND wfr2.orig_system = wfr1.orig_system
AND wfr2.name <> wfr1.name)
ORDER BY orig_system
SELECT orig_system,
description,
orig_system_id,
name "Login Name",
display_name "Employee Name"
FROM wf_local_roles wfr1
WHERE (wfr1.orig_system <> 'WF_LOCAL_ROLES' AND wfr1.orig_system_id <> 0)
AND EXISTS
(SELECT 'row found'
FROM wf_local_roles wfr2
WHERE (wfr2.orig_system <> 'WF_LOCAL_ROLES'
AND wfr2.orig_system_id <> 0)
AND wfr2.orig_system_id = wfr1.orig_system_id
AND wfr2.orig_system = wfr1.orig_system
AND wfr2.name <> wfr1.name)
ORDER BY orig_system
No comments:
Post a Comment