HI all,
This is venugopal.Being a silent member of this group.I am having a doubt
regarding writing a query.I can explain it with an example
Consider i have a table called GetParents
The table consists of two fieds called num as Integer
ParentNum as Integer
The table consists of the following data
num ParentNum
1 4
2 1
3 5
6 7
4 2
Now the output should be as follows if i have given input as 4
then output should be as
num ParentNum
1 4
2 1
4 2
Explaination of Output:
As the given input is 4.Input is compared with num and we get 4->
2.Now ParentNum is taken and checked in the table for 2 being the num and
compared and 2->1 is obtained and now again the comparision is taken and
1->2 is given as ouput
NOw the problem.Can we get the result by writing only one query or we
have to write more no of queries.If it is possible to get this with one
query then can u please give me the query.
Can u give me the query or tell me the source where i can get examples
of such queries.
It will be very much helpful for me.
Thanks in advance,
Regards,
venu.
