Recursiv/hierarchical query?

[Paul Gaspar]

Yes, I think its possible in MS SQL and Orcale, and part of SQL99.  
(START WITH ... CONNECT BY)

Paul



Am 30.12.2008 um 14:34 schrieb william humphrey:

> Without writing the joins? Is this something available in other SQL?
>
> On Tue, Dec 30, 2008 at 9:22 AM, Paul Gaspar  
> <devlist at revolversoft.com>wrote:
>
>> Hi all,
>>
>> is there a way to create recursive/hierarchical selects within
>> Valentina SQL?
>>
>> Something which finds all childs, grandchilds and so on within a
>> table, performs the query on every item and unions the result?