You need to use a recursion query. See the SQL reference manual for syntax.
Regards,
Dave
David W. Roth Teradata Certified Master TERADATA
Recent Threads
Attachments
Library
Quick Reference
Useful Links
Rules of Conduct
FAQs
Join the Forum
Archives
Sample Index
2007 Indexes