WITH RECURSIVE issue

Database
Enthusiast

WITH RECURSIVE issue

Hi ,

I want to find the all dependent jobs on one job. SO table2 had full dependncy data of what is dependant on what.

Is there any way I can use WITH RECURSIVE and find the complete depth of one job.

this is the query i am using again and again to find dependant jobs

sel * from table1 where job_name in ( sel job_dependent_nm from table2 where job_name ='ABC')

Regards,

Num