select f.failurecode failureclass, p.failurecode problem, c.failurecode cause, r.failurecode remedy from failurelist f left outer join failurelist p on p.parent=f.failurelist and p.type='PROBLEM' left outer join failurelist c on c.parent=p.failurelist and c.type='CAUSE' left outer join failurelist r on r.parent=c.failurelist and r.type='REMEDY' where f.parent is null order by f.failurecode, p.failurecode, c.failurecode, r.failurecode;
Labels: intermediate, report, sql