Re: Recursive closure
From: Philip Lijnzaad <lijnzaad_at_ebi.ac.uk>
Date: Sat, 21 Jul 2001 23:33:28 GMT
Message-ID: <u7r8vvajtz.fsf_at_sol6.ebi.ac.uk>
Date: Sat, 21 Jul 2001 23:33:28 GMT
Message-ID: <u7r8vvajtz.fsf_at_sol6.ebi.ac.uk>
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-08Received on Sun Jul 22 2001 - 01:33:28 CEST
+44 (0)1223 49 4639 / Wellcome Trust Genome Campus, Hinxton
+44 (0)1223 49 4468 (fax) \ Cambridgeshire CB10 1SD, GREAT BRITAIN