We need all the application names which are not registered for the particular Change Request. And we need to send email to respective application groups.
| List A | |
| CR No | App Name |
| CR1 | APP1 |
| CR1 | APP2 |
| CR1 | APP3 |
| List B | |
| App Name | |
| APP1 | Email1 |
| APP2 | Email2 |
| APP3 | Email3 |
| APP4 | Email4 |
| APP5 | Email5 |
OUTPUT: Non matching rows for the particular change request from both the list
| App Name | |
| APP4 | Email4 |
| APP5 | Email5 |
|
|
|
Note: In SO association we have option to get ONLY matching data.