Interview Question in SQL Queries

Question

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