Dear all,
I have two table
Table 1 :
| Employee name | Manager name |
| A | ABC |
| B | BCD |
| C | CDE |
| D | CDE |
| E | HIJ |
| F | EFG |
| G | HIJ |
Table 2 :
| Employee name | Manager name |
| A | ABC |
| B | BCD |
| D | CDE |
| G | HIJ |
| F | EFG |
In the above case Manager name "CDE" and "HIJ" does not have employee "C" and "E" from table 1. So i need to create emails notification where i can write mail to manager "CDE" and "HIJ" stating your employee "C" and "E" has left the organisation kindly delete the data from backend . The mail to manager will be sent individually with their Employee name in mail body .