MySql equivalent of ORacle Connect by Prior clause ?

Hi, Any one knows if MySQL implemented the feature which is equivalent to Oracle's Connect by Prior clause. This is needed for retrieving 'Tree' result set from a table like : thanks BG - Original Message - From: Juan Carlos Escobar Gzz [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent:

Re: MySql equivalent of ORacle Connect by Prior clause ?

On Fri, Jun 06, 2003 at 09:28:47AM -0700, Ben Goswami wrote: Hi, Any one knows if MySQL implemented the feature which is equivalent to Oracle's Connect by Prior clause. This is needed for retrieving 'Tree' result set from a table like : Search the manual for CONNECT BY and you'll see it on