This is more SQL problem then SAP DB problem but may bee somebody can help me.
Or sombody knows links where solved this problem.
I have a table ADDRESS. Data represent tree structure. PARENT_ID points into record of the same table.
CREATE TABLE "ADDRESS" ( "ID" Integer NOT NULL DEFAULT SERIAL (1), "PARENT_ID" Integer DEFAULT -1, "NAME" Varchar (30) ASCII DEFAULT '', )
I want to select all records and sort result preorder or postorder.
I'am sorry for my question in this list, but I feel helpless. Thanks for all sugestions.
Dusan
-=x=- Skontrolované antivírovým programom NOD32
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
