t1 = table(2021.01.01..2021.01.30 as date, take(`A`B`C`D`F`G`F, 30) as code) t2 = table(2021.01.15..2021.02.28 as date, take(`A`B`C`D`F`G`F, 45) as code) // 方式一 timer select date, code from lj(t1, t2, `date`code) where isNull(t2.date) and isNull(t2.code) // 方式二 t = select date,code from ej(t1,t2,`date`code) myDict = dict(t.date, t.code) select * from t1 where conditionalFilter(code, date, myDict) == true