Combine 2 table into another table

[TonyWang]

Hi there,

I have three tables, Table-1, Table-2, and Table-3. Can I combine Table-1[A] and Table-2[B] into Table-3[C]? At the same time, automatically combine Tabe-1[E] and Table-2[F] into Table-3[G].  Any changes in [A],[B],[E] and [F] should affect in [C] and [G]. 

Thank you all!