MATLAB: How do i combine many tables by respective column content

Question

Dear Experiences …

i have three tables ( table A, table B and table C)

table A look like following where first columns contain unique names, and second column contain public names (may contain repeated names)..

      name        sun_name
                 ____________
      Amy        'tomy'    
      Bob        'tomy'     
      Hol        'salmon'    
      Har        'cookies'   
      Sal        'pizza'

second column B look like following

   sun_name       var1(B).....varn(B)
  ____________   _______________
'tomy'         0.0 ....  4.5
'tomy'         4.5 .... 5.2
'salmon'       etc.. 
'cookies'   
'pizza'

table C look like following

   sun_name       var1(c).....varm(c)
  ____________   _______________
'tomy'         0.0 ....  4.5
'tomy'         4.5 .... 5.2
'salmon'       etc.. 
'cookies'   
'pizza'

result table (out) perhaps include all columns .. as follow: out

name     sun_name    var1(B)...varn(B)   var1(C)...varm(C)

the problem here content of name field in table A must be repeated based on other tables ? how to do that please.

Answer 1

Maybe so?

Table_out = [A,B(:,2:end),C(:,2:end)];

Added:

As said by Guillaume about innerjoin:

A = readtable('1.xls');
B = readtable('2.xls'); 
C = readtable('3.xls');
Tout = sortrows(innerjoin(A,innerjoin(B,C)),1);