The scenario involves two tables with the following structures : 

```
>table e1:

Id    Name    Addr
---------------------
1     Ramas
2     Sam
3     Musa
4     Sebi

>table e1_addr:

Id   Addr    Mod_Date
-----------------------
1    Gzb     10-05-2018
1    Dli     18-05-2018
2    Gzb     25-05-2018
2    Dli     22-05-2018
3    Gzb     09-05-2018
3    Dli     05-05-2018
4    Gzb     14-05-2018
4    Dli     24-05-2018

```

table `e1` has 4 personnel with no updated addresses in `address` column.
table `e_addr` has updated address record for each id with `mod_date` column having the date the record was entered.

I need to update table `e1` so that its `addr` column has the value from the `e1_addr` table with maximum `mod_date`.

On my part, I have tried to fetch `addr` from `e1_addr` table corresponding to the `max(mod_date)` but cannot achieve the desired result. 

Desired output is as follows :

```
Final Table :

Id   Name   Addr
------------------
1   Ramas   Dli
2   Sam     Gzb
3   Musa    Gzb
4   Sebi    Dli

```

Any and all help would be apprecited.

Please inform if i should give in some more details.