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 <[EMAIL PROTECTED]> 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 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 Links
--------------------------------------------------------------------
Krishan Kant Chamoli Office: +91-172-2653886
Sikhya Solutions (P) Ltd., Fax: +91-172-5018485
24/3, Industrial Area, Phase - 2, Mobile: 9888263726
Chandigarh. INDIA. Pin - 160002. Email: [EMAIL PROTECTED]
--------------------------------------------------------------------
Send instant messages to your online friends http://uk.messenger.yahoo.com
[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=12hl8867p/M=362131.6882499.7825260.1510227/D=groups/S=1705006764:TM/Y=YAHOO/EXP=1123741017/A=2889191/R=0/SIG=10r90krvo/*http://www.thebeehive.org
">Get Bzzzy! (real tools to help you find a job) Welcome to the Sweet Life
- brought to you by One Economy</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/
