adoc

select a.*,b.*,isnull(b.status,0) as q_Statis from  (
SELECT
a.queue_id,
a.job_status ,
a.seq_id ,
a.job_id ,
b.job_parent_id,
a.job_start_time FROM Hermes.dbo.job_queue a left join  Hermes.dbo.job_dependency b
on
a.job_id  = b.job_id where
a.job_status IN (0,1,3) --AND
--a.seq_id  =  (SELECT MIN (seq_id) FROM Hermes.dbo.job_queue WHERE job_status IN (0,1,3)  )
) a
left join
(
  SELECT
  b.job_parent_id,  a.queue_id ,  a.seq_id  ,    a.job_status as status from
 Hermes.dbo.job_queue a join 
 Hermes.dbo.job_dependency b
 on a.job_id = b.job_parent_id --where   a.seq_id  = (SELECT MIN (seq_id) FROM Hermes.dbo.job_queue WHERE job_status IN (0,1,3))
)b

on  a.job_parent_id = b.job_parent_id

where isnull(b.status,0) in (0,1,3)