for me a recursive sql statement is when the result of a query can be used for a following query. the statement has start and stop condition. such kind of queries is useful for tree traversal. sql is based on relational algebra that does not allow to write such expressions. but as mentioned by rudy metzger some databases defines extensions to sql, oracle uses "connect by". db2 has another apporach using "with".
best regards benny
