Recursive closure

I have a table with a recursive relation. Something like: tblName(Number (PK), Name, SuperNumber (FK) )

I would like to create a query who gives all the names at all the levels. (number differs from record to record) You can't do that in SQL2, but I heared it was possible in SQL3.

How do you write this in relational algebra?

Does someone know where I could find this information?

tia
Tim Received on Wed Jul 04 2001 - 17:40:22 CDT