query output

Pawan Kumar · #1 (**permalink**) 07-15-10, 03:50

Hi All,
There is one table and have self reference . I want some output from that table as per some condition.

Table A---
Records Like--
PKAID FKAID
1 NULL
2 1
3 1
4 3
5 2
6 NULL
7 5

If I give input PKID=1 then output must be like below as I need only PKAID..

PKAID
1
2
3
4
5
7

If I give input PKID=3 then output must be like below as I need only PKAID..

PKAID
3
4

If I give input PKID=6 then output must be like below as I need only PKAID..

PKAID
6

It seems here will be used recursive type query or pl/sql but how not getting
Please suggest some solution for the same...

Regards

r937 · #2 (**permalink**) 07-15-10, 06:16

Quote:

Originally Posted by Pawan Kumar

It seems here will be used recursive type query or pl/sql but how not getting

there is no recursive functionality in mysql

there is no pl/sql language in mysql

Pawan Kumar · #3 (**permalink**) 07-15-10, 08:52

by creating procedure or function?if yes what will be logic?

dav1mo · #4 (**permalink**) 07-15-10, 09:54

run the same query until you find there are no more child rows. Meaning:

Code:

select fkaid from table where pkaid =&pk

select fkaid from table where pkaid = "the fkaid you just got"

and keep running this til there are no rows returned.
Dave

Internet Services

Web Development

Digital Marketing

Consumer Tech