I may be missing something, but how is this tree data? All I see is a table (as displayed below) that is then selected so it's in a different order.
What is the purpose of this, i.e. where is this data going in the end? From: Ryan Olshan [EMAIL PROTECTED] Use ANSI Joins, instead of self joins, something like the below: SEECT M1.Name As Parent, M1.Id As ParentId, M2.[name] AS Child, M2.Id AS ChildID FROM Member M1 INNER JOIN Member M2 ON M2.Id = M1.Parent Ryan On 8/10/05, krishan kant chamoli wrote: > > Hi Riyaz, > > In order to make tree view you have to perform self join > > Say Table Name: Member > > SELECT M1.Name As Parent, M1.Id As ParentId, M2.name As > Child, M2.Id As ChildID > FROM Member M1, Member M2 > WHERE M1.Id = M2.Parent] > > Thanks & Regards > > Krishan Kant > > Yusrizal Fahmi wrote: > 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 it's a tree data, but I don't have a clue how to make the > result. > Please help me. > > > > Thanks -- Thank you, Ryan Olshan [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=12h9qt18e/M=362329.6886308.7839368.1510227/D=groups/S=1705006764:TM/Y=YAHOO/EXP=1123742726/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/
