troubleshooting Question
Can some one help with this Sql
I have a table 'a' like this
parent child
9 10
9 11
I have a table 'b' like this
ID primary_id primary_name type
1 9 cal big
1 9 cal small
2 9 cal big
2 9 cal small
4 10 Nev small
4 10 Nev big
3 16 Ill big
I want the output like this ( For the primary_id in table 'b' I want the parent of and child of to be populated based
on table 'a' in the out put .
ID primary_id primary_name type parent of child of
1 9 cal big 10 null
1 9 cal small 10 null
1 9 cal big 11 null
1 9 cal small 11 null
2 9 cal big 10 null
2 9 cal small 10 null
2 9 cal big 11 null
2 9 cal small 11 null
4 10 Nev small null 9
4 10 Nev big null 9
3 16 Ill big null null
Thanks in advance
parent child
9 10
9 11
I have a table 'b' like this
ID primary_id primary_name type
1 9 cal big
1 9 cal small
2 9 cal big
2 9 cal small
4 10 Nev small
4 10 Nev big
3 16 Ill big
I want the output like this ( For the primary_id in table 'b' I want the parent of and child of to be populated based
on table 'a' in the out put .
ID primary_id primary_name type parent of child of
1 9 cal big 10 null
1 9 cal small 10 null
1 9 cal big 11 null
1 9 cal small 11 null
2 9 cal big 10 null
2 9 cal small 10 null
2 9 cal big 11 null
2 9 cal small 11 null
4 10 Nev small null 9
4 10 Nev big null 9
3 16 Ill big null null
Thanks in advance
Learn from the best
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.
Our community of experts have been thoroughly vetted for their expertise and industry experience.