how to link two tables to main table without linking them

[Mark18]

Hi Guys,

I have three different tables. A ,B,C 

All of them have a column called XYZ. I know that if we have same column name in two different tables it will automatically be linked. But the problem is as follows:

A here is the parent table. B and C are derived from it.

How can i link A and B & A and C by using column XYZ without linking B and C.

[JuanGerardo]

NewA:

Load XYZ AS XYZ_A

Resident A;

NewB:

Load XYZ AS XYZ_A,

Load XYZ AS XYZ_B

Resident B;

NewC:

Load XYZ AS XYZ_B

Resident C;

JG

[Mark18]

For this the association will be 

A linked to B 

B linked to C 

Right?

[JuanGerardo]

Right, I understood A --> B --> C, in case A --> B and A --> C, you could use:

NewA:

Load

XYZ AS XYZ_B,

XYZ AS XYZ_C

Resident A;

NewB:

Load XYZ AS XYZ_B

Resident B;

NewC:

Load XYZ AS XYZ_C

Resident C;