参考
http://www.foxtable.com/webhelp/scr/2721.htm
或者直接设置,如
"fid in (select fid from 表2 where fdate='2018-05-31')"