this is my first post

I have a Table A as Master Data
I have a Table B as details of A

Join Field A.Z = B.Z

I would like all fields of A but changing the information of A.Z with B.Z


Area as A
Employee as B

I would like the table A with all the informations of the Area but replicated for each Employee B

I Hope it's clear my question