How i can do a recursive sql query

From: Ronald Berube <Berube.ronald_at_tourisme.gouv.qc.ca>
Date: Fri, 10 Jul 1998 15:17:47 -0400
Message-ID: <35a6698d.0@news.total.net>

I would like to know how i can do a recurvie sql. I have a table who contain the history (descendance) of famely (father, son)

table description     father     char(20)
                                  sun         char(20)

in that table we have all the generation of a famely. Ex : Select * from table.
Father Son

John       Luc          1e generation
Luc         Erik         2e generation
Erik         Ron        3e generation
Ron        Guy         4e generation
Ben        Roger     1e generation

What i would like to do is to extract with one sql all the associate record, in same famely (ectract all record from John to Guy (4 record), if i give John for father, or only Ben if i gave Ben for father). Remenver i do not know the number of generation i will have in the table.

Thank's for anay suggestion.

Ronald
berube.ronald_at_tourisme.gouv.qc.ca Received on Fri Jul 10 1998 - 14:17:47 CDT