Hello,
I have table which has parent-child relationships between rows. How
can I write a query (stored procedure) that given a parent id selects
all childs?

Firebird server 2.1

Thanks