: SELECT PARENT,        CHILD,        LEVEL,        QTY FROM   BMST WHERE  PARENT = '000'  would return: PARENT | CHILD  | LEVEL | QTY  ----------------------------- 000    | 000    | 0     | 0 000    | 000    | 0     | 0 000    | 000    | 0     | 0  The LEVEL value 