How to join Transaction ID with Assignment Identifier
Summary:
We are trying to join "Compensation - Individual Compensation Real Time" with "Human Capital Management - Approval Notification Archive Real Time". This is so that we can report on the compensation data alongside the comments that were included in the approval workflow for these approved transactions.
We have tried joining the Transaction ID in Compensation subject area with Assignment Identifier from another analysis as per other discussions in Customer Connect however we get an error message. Is anyone able to advise how to correct our SQL?
Thank you.
Content (please ensure you mask any confidential information):
SQL attached.
Version (include the version you are using, if applicable):