Hello guys, i have a table that references to it self, it looks like:
menu_id, menu_label, menu_parent.

If parent is diferent from zero, i want to show the menu_label of the parent
one. Does anyone know how to do it? I've tryied with sub-selects but with no
success.

Thanx

--
Rosivaldo Azevedo Ramalho
Decisão Informática
www.decisaosotf.com.br
rosivaldo@...
+55 83 8803 0969