Create a hierarchy from three tables.

[#1]

Dear all,

I have the following Question:

I have three tables like this:

Field: A B C

Table 1: 1

Table 2: 1 2

Table 3: 2 3

Now i need to create a table the shows the folowing information:

Tabel 4: A B C

Row 1: 1 - -

Row 2: 1 2 -

Row 3: 1 2 3

It's a Hierachy. Does anyone know how to do this?

Regards,

Frank

[suniljain]

pls check attached file.

[#3]

Thanks for your quick response!

I don't think this is my awnser (or maybe i am wrong).

Your Products ' hierarchy' is found inside ONE table 'Ancestors' , but I have THREE tables.

[#4]

Hi fbeunder,

Could you please explain the problem with more data from each table1,table2 and table3?

[#5]

Field: A B C

Table 1: 1

2

Table 2: 1 2

1 4

2 2

Table 3: 2 3

4 5

Tabel 4: A B C

Row 1: 1 - -

Row 2: 1 2 -

Row 3: 1 2 3

Row 4: 1 4 -

Row 5: 1 4 5

Row 6: 2 - -

Row 7: 2 2 -

Row 8: 2 2 4

Is this sufficient?