Sir,
I have a table named "RELATIONS_MAST ER". Content of the table is below.
CODE | PARENT | CHILD | LEVEL |
--------------------------------------------------------------
A01 | Red Bull | Red Eye | 01
B01 | Blue River | Blue Gun | 01
A11 | Red Eye | Red Sand | 02
A21 | Red Sand | Red Rock| 03
B11 | Blue Gun | Blue Bell | 02...