* Get parent records into the cursor
>>SELECT * FROM ParentTable ;
>>  WHERE &lcFilter ;
>>  INTO CURSOR crsParent
>>* Now join a cursor with child table
>>SELECT ...
>>