List:General Discussion« Previous MessageNext Message »
From:John Millaway Date:September 7 1999 1:28pm
Subject:RE: Recursive Subqueries
View as plain text  
Just curious, what's a recursive subquery? (As opposed to a normal
subquery.)


> Hello,
> 
> I'm trying to create a category tree using one table. This 
> table will have
> an auto-increment ID field, and a parent_ID field which will 
> refer to an ID
> field.
> 
> Through a SQL statement that will create different aliases 
> for the same
> table, I should be able to create a hierarchial view of the 
> relationships.
> This works on Oracle.
> 
> I'm not sure, but I remember seeing that MySQL does not 
> support recursive
> subqueries. If this is true, does anyone have an indication 
> as to when it
> might? I cannot find any mention within the documentation or FAQ.
> 
> Thanks,
> Andy
> 
> ========================
>  Andy Brown
>  brown.andy@stripped
> ========================
> 
> 
> 
> 
> ________________________________________________________________
> Get FREE voicemail, fax and email at http://voicemail.excite.com
> Talk online at http://voicechat.excite.com
> 
> ---------------------------------------------------------------------
> Please check 
> "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail 
> mysql-thread12408@stripped
> 
> To unsubscribe, send a message to the address shown in the
> List-Unsubscribe header of this message. If you cannot see it,
> e-mail mysql-unsubscribe@stripped instead.
> 
Thread
Recursive SubqueriesAndy Brown7 Sep
  • Re: Recursive SubqueriesMartin Ramsch7 Sep
RE: Recursive SubqueriesJohn Millaway7 Sep