Team,
Please help me on this following problem. for examples I have a data: Id name level parent --------------------------------------------------------------- 1 Director 1 0 2 Marketing 2 1 3 Sales 2 1 4 Marketing Staff1 3 2 5 Marketing Staff2 3 2 6 Sales Staff1 3 3 7 Sales Staff2 3 3 8 Sales Staff3 3 3 I want to make a sql syntax to produce result like: Id name level parent --------------------------------------------------------------- 1 Director 1 0 2 Marketing 2 1 4 Marketing Staff1 3 2 5 Marketing Staff2 3 2 3 Sales 2 1 6 Sales Staff1 3 3 7 Sales Staff2 3 3 8 Sales Staff3 3 3 Basically its a tree data, but I dont have a clue how to make the result. Please help me. Thanks rizal -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.338 / Virus Database: 267.10.5/67 - Release Date: 8/9/2005 [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> <font face=arial size=-1><a href="http://us.ard.yahoo.com/SIG=12htfjc5c/M=362329.6886308.7839368.1510227/D=groups/S=1705006764:TM/Y=YAHOO/EXP=1123685105/A=2894321/R=0/SIG=11dvsfulr/*http://youthnoise.com/page.php?page_id=1992 ">Fair play? Video games influencing politics. Click and talk back!</a>.</font> --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
