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 the TODO list. -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 4.0.13: up 3 days, processed 124,611,241 queries (392/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]