SELECT KeyField from AnotherTable Into Cursor KeyCursor SET RELATION TO KeyField INTO Mytable SCAN ... ENDSCAN>I want to process, in a SCAN loop, all records that satisfy a given condition. The condition is most easily expressed as a SELECT - SQL - but what is the best way to combine the two?
>Pseudocode: > >SCAN where KeyField in (SELECT KeyField from AnotherTable) > ... >ENDSCAN >>