General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only