Select * From (lcFile) Into Cursor curDummy Readwrite Where activity="Passed - waiting for source" Select * From (lcFile) Inner Join curDummy On &lcFile..rma=curDummy.rma Into Cursor (lcFile) Readwrite>You're missing the point that we don't know RMA. That was just a sample. We need to get all the records that have the same rma as the one with "Passing date"
>>SELECT * FROM (lcReturn) ; >> WHERE RMA=3 AND EMPTY(date_end) ; >> INTO CURSOR (lcReturn)>>Or am I missing something?