outer join for parent child chain
- by dotnetcoder
Considering below tables and relationships:
parent --1:Many-- children --1:Many-- shubchildren
Parent may or many not have children
records.
children always have subchildren records.
I wan to write a qiery to select parent names where any if matched
parent.name,children.name or subchildren.name
Here i understand I have to do a left outer join between parent and children. But what kind of join should I put between children and subchildren ?