AVOIDING SYN TABLES. SELF JOINING TABLE

[christian77]

Hi:

I have a self joining table that I want to load in QV associative way. The result is that I get 7 syn. tables from only 3 tables and I think that is too much. Can anyone help me?

I’m attaching exact example.

Self joining explanation.

When nivelzona = 1, then zona = zona

When nivelzona = 2, then zona = sector

When nivelzona = 3, then zona = base

Thanks.

[christian77]

Ok, someone solved it for me using the function Hierarchy.