subhransu123
Journeyman
There r two table .....
Person(pid,name,city)
parent(parentid,childid)
both parentid and childid are foreign key refering to person.pid
1. Find the name of gradparents of all people whose city name is kolkata.
2. Find the name of all people who lived in the same city as their father.
Please help to solve it.........
Person(pid,name,city)
parent(parentid,childid)
both parentid and childid are foreign key refering to person.pid
1. Find the name of gradparents of all people whose city name is kolkata.
2. Find the name of all people who lived in the same city as their father.
Please help to solve it.........