SELECT * ; FROM lineitem ; WHERE RecType = "A" ; UNION ALL ; SELECT * ; FROM lineitem t1 ; WHERE RevNum IN ( SELECT MAX(RevNum) ; FROM lineitem t2 ; WHERE RecType = "I" ; AND t2.ParentId = t1.ParentId ; AND t2.LineId = t1.LineId ) ; ORDER BY 2, 3, 4 ; INTO CURSOR crsResult>I have a header/lineitem problem.
>RecordId DocId RevNum >------------------------------------ > 1 0001 3 >>
>RecordId ParentId LineId RevNum OrigRev RecType >------------------------------------------------------------ > 1 0001 123 1 999 I > 2 0001 123 2 999 I > 3 0001 123 3 999 A > 4 0001 890 1 999 I > 5 0001 890 2 999 A > >>