How can i Left Join() multiple tables?

[Mattia]

Hi guys,

i have four tables: A, B and C.

I need to bring all the fields of table C in table B and all the fields of table B in table A.

What's the right expression to do this?

Thanks,

Mattia

[Mattia]

Hi,

here is attached the sample data file.

In the script, there are all the tables involved.

I need to join the tables in the following way:

from COM to TES

from TAR to DET and from DET to TES

from TAR to AMB2

from COM to AMB1 and from AMB1 to AMB2

So, i want this: all the fields of tables COM and TAR both in tables TES and AMB2.

I've tried also with applymap() but don't work. Other ideas are welcome!!!

Thanks,

Mattia