>>I have a table with the follow records:
>>
>>IDCMP CHILDIDCMP IDISM
>>1 NULL 10507
>>2 NULL 10485
>>3 NULL 13259
>>4 NULL 14987
>>4 16 NULL
>>10 1 NULL
>>16 NULL 14000
>>16 3 NULL
>>16 10 NULL
>>
>>I need to retrive ALL values of IDISM included in a IDCMP. For example: the values from IDISM in IDCMP = 4 are 14987,14000,13259,10507. Is it possible to use a recursion SQL statement to do this?
>>
>>I would appreciate any help that could be given.
>>
>>Thanks in advance.
>>Augusto.
>
>I don't understand what you mean by "included" here. Can you explain it?
>
>Vlad

Hi Vlad,

Sorry for my english. I will try to explain my problem.
I have a table with a autorelation (column IDCMP relates with CHILDIDCMP). The column IDCMP would be the identification from a composition of elements (column IDISM). One composition can refer to one or more composition and elements. For example: composition 4 refers to composition 16 (that by your time refers to composition 3 e 10, and so on...) and element 14987. I need to track all the elements that are parts of a composition AND in all "subcompositions" related with it (I need to expand an encoded hierarchy).

Thanks.
Augusto.