Post
Ask Question

Find Parent's parent through query

  1. Select s.Column, i.Column  
  2. from table1 s, table2 r,table4 j,table3 p,table5 i  
  3. where p.Id=j.PId  
  4. AND j.JOB_REFERENCE_NUMBER=r.JOB_REFERENCE_NUMBER  
  5. AND s.SKID_NUMBER=r.SKID_NUMBER  
  6. AND i.LOCATION_ID = j.LOCATION_ID  
  7. AND j.JOB_REFERENCE_NUMBER='Val'