how to get parent and child record in single query using sql

Solutions on MaxInterview for how to get parent and child record in single query using sql by the best coders in the world

Search
showing results for - "how to get parent and child record in single query using sql"
Lea
18 Nov 2019
1SELECT child.Id,
2       child.Name,
3       child.ParentId,
4       parent.Name as ParentName
5FROM your_table child
6JOIN your_table parent ON child.ParentId = parent.id;
7
similar questions
error 1451 2823000 29 3a cannot delete or update a parent row 3a a foreign key constraint failsparent and child link in mysql
queries leading to this page
mysql query to get parent child recordssql get parent from childreturn parent child results sqlhow to get parent and child records in single query using sqlhow to get parent and child record in single query using sql not using ctesql query to get parent child recordshow to find parent child relationship in sqlget parent child sql queryselect query to fetch parent and grand parent in sqlhow to get parent and child record in single query using sql stored proceduresql query to get parent child relationshipsql select parent and child recordshow to get parent and child record in single query using sqlhow to get parent and child record in single query using sql