recursion - How to create infinite treeview through sql recursive query -

recursion - How to create infinite treeview through sql recursive query -

would appreciate if help create recursive query create infinite treeview. sample info , output has been shown below ready reference.

contents of details field root elements not have 'groupcode'.

table info (example table name 'area') ========================================= >groupcode code details (continent/country/province or division/city/area/street) >========= ==== ================================================================= > 1 asia > 2 europe > 3 africa > 4 north america > 5 south america > 6 commonwealth of australia > 7 antarctica >1 8 people's republic of bangladesh >1 9 republic of india >1 10 islamic republic of pakistan >8 11 dhaka >8 12 chittagong >12 13 agrabad >12 14 new-market >12 15 halishahar >9 16 west bengal >16 17 kolkata (calcutta) >17 18 xyz area >13 19 road no. 111 >13 20 road no. 222 > >tree view >======================================================== >-> (1) asia > -> (8) people's republic of bangladesh > -> (12) chittagong > -> (13) agrabad > -> (19) road no. 111 > -> (20) road no. 222 > -> (14) new-market > -> (15) halishahar > > -> (9) republic of india > -> (16) west bengal > -> (17) kolkata > -> (18) xyz area >

thanks, nowshad (cell # +880-1713-442068)

sql recursion treeview