Plz help me in a query..

Question

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...........

Upendra Pratap Shahi · Answer

Which you want that is not logically true because you are using parent and child concept.

Dilshad Ali · Answer

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 Banger · Answer

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 Ali · Answer

SELECT H2.Id H1.Name as Header H2.Name as Parents FROM Header H1 Right JOIN Header H2 ON H2.PID=H1.ID ;