Need to write a sql statement that find all sub organization records to the parent organization

Question

I need to write a sql statement that find all sub records which has many level meaning the parent record has 2nd level and 3rd level child records tying to the parent organization. So far I wrote

SELECT *
  FROM tblOrganization
  where Parent_Org_ID = '11111'

How can I write a sql statement that will give me all the child records (2nd, 3rd level so on) tying to the parent ID record?

Thanks

Please mention the database you are using. And it is recommended to show what you have done so far, so we can start from there. — Ely, Jul 07 '15 at 19:54
If you're using SQL server, you'll want to use a recursive common table expression. — Brian Driscoll, Jul 07 '15 at 19:56
Can you please provide a sample data set with field names of your parent child relationship? — Random Developer, Jul 07 '15 at 19:57

score -3 · Answer 1 · edited May 23 '17 at 11:43

-3

You will need to look for an alternative to Oracle Connect By prior in SQL Server, the following link answers your requirement.

Simulation of CONNECT BY PRIOR of ORACLE in SQL SERVER

edited May 23 '17 at 11:43

Community

1
1

answered Jul 07 '15 at 20:02

Vicky21

95
5

Need to write a sql statement that find all sub organization records to the parent organization

1 Answers1