I have created a table which have Parents and its Children. But the User Needs a Sort field which gives the expanded Hierarchy of the Parent. Example given below. PLease let me know how to achieve this in Teradata.
*087P001 -- 087P001
Whats the structure of the table? Parent & child are in separate columns or in one? Have you tried ORDER BY Parent, Child?