Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>>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.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement