Urgent Help needed

[mansi_dv]

Hii all,

Attached is a sample of my application.

I need to do the following:

if a=b and c is not null, then check for the value of c in b and get the corresponding value in c. Continue till c is null. Get the final value of b in d. For eg, in the attachment,

a          b          c          d

1          1          c1

5          5         

2          y          c2

3          c1        c3

x          c3         

y          3           c5

z          4           c6

a=b=1, so we check the value of c ie 'c1' in b. Now, 'c1' in b corresponds to 'c3' in c. So we check 'c3' in b and find null in c.

Thus my desired out put is 'c3' in d.

How can we achieve this?

[DavidFoster1]

I think you need to break up the data more logically.

The first thing I would do is separate your A=B records into a separate table.

You then need to create a hierarchy table (I am assuming that there can be any number of levels before you reach a C=Null record.

The trick then will be to use the hierarchy table to lookup the Root node that applies to each record in your A=B table.

[mansi_dv]

Thank you for the reply David. Yes, there can be any number of levels before c=null. Can you explain what is hierarchy table and how to use it?