This is recursion in action. Different DBMS products implement recursive SQL in different ways. Recursion is implemented in standard SQL-99 using common table expressions (CTEs). DB2, Microsoft SQL ...

Here's the deal: I have a database with table called Categories. Categories has a parent-child relationship in them. Here's what the table looks like (exluding stuff not related to the problem ...

BR><BR>I know in 2005 this can be done with recursive table expressions, but this table is stored on SQL 2000 so I don't think those will be doing me any good in this case.