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"
Since Rich is using VFP8 the only way would be to do in two steps. In VFP9 syntax with derived tables work fine, but IN and EXISTS don't work.
>You've got it all wrong, your query will give the same result as Sergey's. This query will give the data you want:
>SELECT * FROM (lcReturn) ;
> WHERE RMA=3 AND EMPTY(date_end) ;
> INTO CURSOR (lcReturn)
>Or am I missing something?
>
If it's not broken, fix it until it is.
My Blog