Hierarchical System Tables

[r***@gmail.com]

People,

I want classify my table according constraint foreign key.

Example:

Table - Foreign Key

a -
b -
c - a
c - b
d - a
d - b
d - c

Can i generate a hierarchical recursive query for this? How?

[Roberto Carneiro da Silveira Junior]

New Example, more clear

Primary Table - Foreign Table

C -
D -
A - C
F - D
B - D
B - A
L - C
L - F
I - B
I - L