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')