LOCAL cmemvar =SYS(3054,11,"cmemvar") SELECT ... _CLIPTEXT = cmemvar>>You can try
>>* JOIN >>SELECT cr.plot_id ; >> FROM crzplots cr ; >> JOIN imsfilter ON linkfield = cr.plot_id ; >> INTO CURSOR cPlots >> >>* Correlated subquery >>SELECT plot_id ; >> FROM crzplots ; >> WHERE EXISTS (SELECT * FROM imsfilter WHERE linkfield = plot_id) ; >> INTO CURSOR cPlots>