Re: recursive queries

[Duncan Miller]

I am looking to do a query on a self join table that returns the parent 
records.

Obviously there are ways to do this, but just wondered if there are any 
functions in MySQL that make this easier, or specific functions 
available to stored procedures. I have read the manual and couldn't find 
anything, but thought I would ask.

I notice that the new MS SQL Server has support for recursive queries 
and oracle also, so I thought maybe...

Thanks