Hi everyone.
I have following table in SQL:
id person
1 Ben Parker
2 May Parker
3 Peter Parker
I am looking for some sort of coding in SQL that gives me following result:
id relationship
1 Ben Parker is the husband of May Parker.
2 Ben Parker is an uncle of Peter Parker.
3 May Parker is the wife of Ben Parker.
4 May Parker is an aunt of Peter Parker.
5 Peter Parker is a nephew of Ben Parker.
6 Peter Parker is a nephew of May Parker.
Can anyone guide me how many tables I will have to create and how to get the desired result??