Plz help me in a query..

Dilshad Ali

11y1kSQL

Table Name : Header

Id Name Pid

1 KYC

2 AP 1

3 IP 1

4 Security

Query:

SELECT H1.Id, H1.Name as Header, H2.Name as Parents
FROM Header H1
LEFT JOIN Header H2 ON H1.PID = H2.Id;

out put:

id header parents

1 KYC Null

2 AP KYC

3 IP KYC

4 Security Null

But actually i want

id header parents

1 KYC Null

2 KYC AP

3 KYC IP

4 Security Null

plz reply me...........

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Upendra Pratap Shahi11y ago
Which you want that is not logically true because you are using parent and child concept.
Dilshad Ali11y ago
Step 1 :This is my table.... (with data)
------------------------------
Table Name : Header

Id        Name       Pid
1          KYC         null
2          AP             1
3           IP              1
4        Security        null

Step 2 : I write Query and get out put
------------------------------------------

Query:

SELECT H1.Id, H1.Name as Header, H2.Name as Parents
FROM Header H1
LEFT JOIN Header H2 ON H1.PID = H2.Id;

Step 3 :After writing this query i get such output
---------------------------------------------------------------------

out put:
id        header       parents
1          KYC          Null
2           AP             KYC
3          IP                KYC
4      Security          Null

Step 4 :But actually i want such out put
---------------------------------------------------------------------

id             header                parents
1                KYC                   Null
2                KYC                    AP
3                KYC                     IP
4                Security               Null
Joginder Banger11y ago
Hi Dilshad Ali,
Sorry i can't understand whats you trying, I little bit silly read your question very carefully and after move to again post answer. What is this Ali G.

_jsb
Dilshad Ali11y ago
SELECT H2.Id, H1.Name as Header, H2.Name as Parents
FROM Header H1
Right JOIN Header H2 ON H2.PID=H1.ID ;