Hello.
Though I haven't read this article, but its title looks promicing:
http://dev.mysql.com/tech-resources/articles/hierarchical-data.html
Duncan Miller wrote:
> 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
>
>
>
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ suppressed
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/suppressed
Mail converted by mhonarc 2.6.15
This archive provided courtesy of JSW4.NET, Internet Hosting Services for Small Business.