List:General Discussion« Previous MessageNext Message »
From:Thimble Smith Date:September 9 1999 6:47pm
Subject:Re: A Recursive Subquery is...
View as plain text  
At 09:28, 19990909, AJBE (E-mail) wrote:
>A recursive subquery uses one table mutliple times as different aliases in
>order to join to itself.
>
>id
>parent_id
>name

You can do queries like this in MySQL:

    SELECT id, parent_id, name
    FROM   Tree t1, Tree t2, Tree t3
    WHERE  t3.name = 'Carp'
    AND    t2.id = t3.parent_id
    AND    t1.id = t2.parent_id

    6  0  Animal
    9  6  Fish
    14 9  Carp

Is that what you're calling recursive subqueries? or something else?

Tim
Thread
Re: A Recursive Subquery is...E-mail)9 Sep
  • Re: A Recursive Subquery is...Thimble Smith9 Sep
    • Re: A Recursive Subquery is...felix k sheng9 Sep
      • Re: A Recursive Subquery is...Thimble Smith10 Sep
        • Re: A Recursive Subquery is...Michael Widenius14 Sep
          • Site ????Jagadish R.R.( ASI 99)14 Sep
            • Re: Site ????Bill Gerrard14 Sep
            • Re: Site ????Christian Mack14 Sep