I have a table CLIENT

```
CLIENT_ID   NAME      CP       VILLE
1           razer     49004    St hallo
2           mayui     49005    Kubol

```

and another table AGENCE

```
CLIENT_ID  AGENCE_ID  ADDR   CP      VILLE     
1           1          qsdf   null    null
2           2          qsdf   null    null
1           9          dqsf   5454    5254
1           5           fff   4587    6568

```

How can i fill the CP and VILLE of table AGENCE ?

Of course i can delete / truncate AGENCE and use SELECT INSERT. But i can not do that.