Hi, i have a table with two fields: id, parentid and name and with this i need to create a query where it shows the childs of the parents and so on. For instance

ID PARENTID NAME
3 LUCIA
4 3 JOHN
5 3 SANDRA
6 4 CARLOS
7 4 NANCY

this should be displayed and reflected in the code according if i choose lucia or sandra (for instance)

Thx.