creating a hierarchy for building tree

comp.database comp.database

Thread Tools

Search this Thread

Display Modes

amitsol (Offline)

Junior Member

Posts: 1

Join Date: Aug 2006

creating a hierarchy for building tree - 08-18-2006 , 07:07 AM

hi guys
I have a table structure like below
Parent Child
PA A1
A1 A11
A1 A12
PA A2
PB A3
PB A12

Now using a view I need to display data in this format
Item Parent ItemID
PA null 1
A1 PA 2
A2 PA 3
A11 A1 4
A12 A1 5
PB null 6
A3 PB 7
A12 PB 8

It would be nice if someone help me....

« Previous Thread | Next Thread »

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off