Re: Recursive closure

On Wed, 04 Jul 2001 22:40:22 GMT,
"Tim" == Tim Galle <38726_at_stud.ehsal.be> wrote:

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

Tim> I would like to create a query who gives all the names at all the levels.

  select name from tblName;

but I sense that this is not what you were after ....

                                                                      Philip

-- 
If you have a procedure with 10 parameters, you probably missed some. (Kraulis)
-----------------------------------------------------------------------------
Philip Lijnzaad, lijnzaad_at_ebi.ac.uk \ European Bioinformatics Institute,rm A2-08


+44 (0)1223 49 4639                 / Wellcome Trust Genome Campus, Hinxton

+44 (0)1223 49 4468 (fax)           \ Cambridgeshire CB10 1SD,  GREAT BRITAIN