Good Day,
I would like your help or opinion regarding what is the best solution for this problem, I want the Email_manager field to be filled up with the data coming from the email field (their personal Email address.
ID_NO | Name | Manger | Email_manager | |
101 | Duke | Duke_03@google.com | Hawk | Hawk_01@yahoo.com |
102 | Falcon | Falcon_15@yahoo.com | Duke | Duke_03@google.com |
103 | Hawk | Hawk_01@yahoo.com | Flagg | |
104 | BeachHead | BeachHead_abc@google.com | Duke | |
105 | Bazooka | Bazok14@gmail.com | Duke | |
106 | Recondo | recon_045@gmail.com | BeachHead | |
107 | Alpine | Pine001@yahoo.com | Falcon | |
108 | Flagg | Flagg03@Gmail.com | Flagg |
Thanks In advance
Solved! Go to Solution.
Hello @Grail030510
You can simply join your table to itself with manager=Name as key of the left join.
Best regards,
Simon