All Forums Database
nambir 7 posts Joined 03/16
18 Jul 2016
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

You must sign in to leave a comment.