Find Parent's parent through query

Chinmaya Dash

10y725Code

Find Parent's parent through query.

Select s.Column, i.Column
from table1 s, table2 r,table4 j,table3 p,table5 i
where p.Id=j.PId
AND j.JOB_REFERENCE_NUMBER=r.JOB_REFERENCE_NUMBER
AND s.SKID_NUMBER=r.SKID_NUMBER
AND i.LOCATION_ID = j.LOCATION_ID
AND j.JOB_REFERENCE_NUMBER='Val'