I found something that we can get all the tree. SELECT cat_id, group_concat( id ) FROM categoria GROUP BY cat_id
Try it and tell me if it´s good or not. ""abhishek jain"" <[EMAIL PROTECTED]> escreveu na mensagem news:[EMAIL PROTECTED] > Hi, > I have a table structure like : > ID , NAME, PARENT_ID > 1 , Top , 0 > 2 , Level 1 , 1 > 3 , Level 2 ,2 > 4 , Another Top , 0 > > > and so on. > I wanted to know the topmost cat. if i have the lowest category id ie. 3 > in > this case. > I wanted to get like 3->2->1 > Pl. help me , cn i do this in one query, also i do not know how many > sublevels are there, > Thanks, > Abhishek jain > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]