SELECT
ConcernRoleDuplicate.originalConcernRoleID,
ConcernRoleDuplicate.duplicateConcernRoleID,
ConcernRoleDuplicate.duplicateDate,
ConcernRoleDuplicate.duplicateDateTime,
ConcernRoleDuplicate.duplicateReason,
ConcernRoleDuplicate.duplicateUser,
ConcernRoleDuplicate.duplicateComments,
ConcernRoleDuplicate.unmarkDate,
ConcernRoleDuplicate.unmarkDateTime,
ConcernRoleDuplicate.unmarkReason,
ConcernRoleDuplicate.unmarkUser,
ConcernRoleDuplicate.unmarkComments,
OrigConcernRole.concernRoleName,
DupConcernRole.concernRoleName,
ConcernRoleMerge.mergeStatus,
ConcernRoleMerge.mergeStartDate,
ConcernRoleMerge.mergeEndDate,
ConcernRoleMerge.mergeStartedBy,
ConcernRoleMerge.mergeCompletedBy,
DupUsers.fullName,
MergeStartedUsers.fullName,
MergeCompletedUsers.fullName,
UnmarkUsers.fullName
INTO
:originalConcernRoleID,
:duplicateConcernRoleID,
:duplicateDate,
:duplicateDateTime,
:duplicateReason,
:duplicateUser,
:duplicateComments,
:unmarkDate,
:unmarkDateTime,
:unmarkReason,
:unmarkUser,
:unmarkComments,
:originalConcernRoleName,
:duplicateConcernRoleName,
:mergeStatus,
:mergeStartDate,
:mergeEndDate,
:mergeStartedBy,
:mergeCompletedBy,
:duplicateUserFullName,
:mergeStartedUserFullName,
:mergeCompletedUserFullName,
:unmarkUserFullName
FROM
(
SELECT
ConcernRoleDuplicate.originalConcernRoleID,
ConcernRoleDuplicate.duplicateConcernRoleID,
ConcernRoleDuplicate.duplicateDate,
ConcernRoleDuplicate.duplicateDateTime,
ConcernRoleDuplicate.duplicateReason,
ConcernRoleDuplicate.duplicateUser,
ConcernRoleDuplicate.duplicateComments,
ConcernRoleDuplicate.unmarkDate,
ConcernRoleDuplicate.unmarkDateTime,
ConcernRoleDuplicate.unmarkReason,
ConcernRoleDuplicate.unmarkUser,
ConcernRoleDuplicate.unmarkComments
FROM
ConcernRoleDuplicate
WHERE ConcernRoleDuplicate.concernRoleDuplicateID = :concernRoleDuplicateID
) ConcernRoleDuplicate
LEFT
JOIN
ConcernRoleMerge
ON ConcernRoleMerge.concernRoleDuplicateID = :concernRoleDuplicateID
LEFT
JOIN
ConcernRole OrigConcernRole
ON OrigConcernRole.concernRoleID = ConcernRoleDuplicate.originalConcernRoleID
LEFT
JOIN
ConcernRole DupConcernRole
ON DupConcernRole.concernRoleID = ConcernRoleDuplicate.duplicateConcernRoleID
LEFT
JOIN
Users DupUsers
ON DupUsers.userName = ConcernRoleDuplicate.duplicateUser
LEFT
JOIN
Users MergeStartedUsers
ON MergeStartedUsers.userName = ConcernRoleMerge.mergeStartedBy
LEFT
JOIN
Users MergeCompletedUsers
ON MergeCompletedUsers.userName = ConcernRoleMerge.mergeCompletedBy
LEFT
JOIN
Users UnmarkUsers
ON UnmarkUsers.userName = ConcernRoleDuplicate.unmarkUser
GROUP
BY ConcernRoleDuplicate.originalConcernRoleID,
ConcernRoleDuplicate.duplicateConcernRoleID,
ConcernRoleDuplicate.duplicateDate,
ConcernRoleDuplicate.duplicateDateTime,
ConcernRoleDuplicate.duplicateReason,
ConcernRoleDuplicate.duplicateUser,
ConcernRoleDuplicate.duplicateComments,
ConcernRoleDuplicate.unmarkDate,
ConcernRoleDuplicate.unmarkDateTime,
ConcernRoleDuplicate.unmarkReason,
ConcernRoleDuplicate.unmarkUser,
ConcernRoleDuplicate.unmarkComments,
OrigConcernRole.concernRoleName,
DupConcernRole.concernRoleName,
ConcernRoleMerge.mergeStatus,
ConcernRoleMerge.mergeStartDate,
ConcernRoleMerge.mergeEndDate,
ConcernRoleMerge.mergeStartedBy,
ConcernRoleMerge.mergeCompletedBy,
DupUsers.fullName,
MergeStartedUsers.fullName,
MergeCompletedUsers.fullName,
UnmarkUsers.fullName
|