Hello guys,
Do anyone know how to write recursive SQL statement for hierarhic output places from next table:
id-----place----------idParentPlace
1......World..........Null
2......Europe.........1
3......Mediterranean..2
4......North Europe...2
5......Italy..........3
6......Greece.........3
7......Island.........4
8......Norway.........4
I was looking for alot of tutorials but didn't find anything useful.
Any help is the most welcome!
Regards,
TP