SQL> select * from states;

       ID$    ACCEPT# CODE
---------- ---------- --------------------
         0
         1            A
         2            AA
         3            AB
         4            AS
         5          1 AAA
         6          2 ABC
         7          3 ASC

8 rows selected.

SQL> select * from trans;

   STATE$# INPUT      NEXT#
---------- ----- ----------
         0 A              1
         1 A              2
         1 B              3
         1 S              4
         2 A              5
         3 C              6
         4 C              7

7 rows selected.