Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
1
Reply
Interview Question in SQL Queries
Vinay K
Aug 31 2017 1:00 PM
274
Reply
How to get the
Output
from below tables?
I have two tables T1 and T2
It has relation between two tables
Table : T1
id
Name
Gender
1
Jhon
Male
2
Root
Male
3
Diana
Female
4
Tony
Male
5
David
Male
6
Riya
Female
Table : T2
child_id
parent_id
1
2
1
3
4
5
4
6
Output :
ch_id
child_Name
Father Name
Mother Name
1
Jhon
Root
Diana
4
Tony
David
Riya
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
1
)
Next Recommended Forum
How to Get Employees Period in Company as per Employee Joini
Is it any row uniquely identify is superkey