Fetching data from child table to another child table

[George_1]

i have two child tables in a module ,

Child table A and B

i want to fetch data of just one field from these child tables to child table C. how can i do this in the same doctype.

[NCP]

Please check the video.

Fetch Child table form one doctype to other doctype

I have given the reference of the video here, maybe it will help someone. [Fetch Data From One DocType To Another | Frappe | ERPNext]