please help me...
i have 2 tables of database..
i contains the parent nodes, and other contain the child node..
e.g
Expand|Select|Wrap|Line Numbers
- first table. CC_ATTRIBUTE. (Which Contains Child Node)
- CC_Id Description CC_Attribute_Type_Id
- 1 Diamond 1
- 2 Gold 1
- 3 Silver 1
- 4 Bronze 1
- 5 High 2
- 6 Meduim 2
- 7 Low 2
- 8 Exclusive 3
- 9 Mix 3
- 10 Key Acount 3
- 11 PCI 3
- 12 Coke 3
- 13 Traditional Store 4
- 14 Modern General Store4
- 15 Bakery 4
- 2nd Table...
- CC_Attribute_type (Which Contains Parent Nodes)
- CC_Attribute_type_id Description
- 1 Sales Status
- 2 Socio Economic Status
- 3 Outlet Status
- 4 Outlet Classification
find the attachement blow....it should look like this...