github.com/matrixorigin/matrixone@v1.2.0/test/distributed/cases/join/markjoin.result (about)

     1  drop table if exists t1;
     2  drop table if exists t2;
     3  Create table t1(sid int, sname varchar(20), mid int);
     4  Create table t2(mid int,mname varchar(20));
     5  insert into t1 values(1,'Seven',1),(2,'Ultraman',2),(3,'Gaia',NULL);
     6  insert into t2 values(1,'James'),(3,'Tiga');
     7  select t1.sname from t1 where not exists (select t2.mname from t2 where t2.mid = t1.mid);
     8  sname
     9  Ultraman
    10  Gaia
    11  drop table if exists t1;
    12  drop table if exists t2;
    13  Create table t1(a int,b int,c int);
    14  Create table t2(d int,e int,f int);
    15  insert into t1 values(1,2,4),(3,4,7),(2,2,5),(5,2,3),(3,NULL,2),(NULL,2,1);
    16  insert into t2 values(2,NULL,1),(3,3,4),(5,5,1),(NULL,NULL,7),(NULL,4,5);
    17  select t1.c from t1 where a not in (select d from t2 where t1.b = e);
    18  c
    19  4
    20  5
    21  3
    22  2
    23  1