ksql中支持not in和not exists,但是具体的语法给sql中的不一样

sql中是先写字段名 后面写not in

如：select productID, productName from Products where categoryID IN (1, 4, 5);

ksql中是要把关系名写到not 和in中间的

如下：SELECT  o1.*, o1.sCode AS sPCode, o1.sName AS sPName FROM SA_OPOrg o1  WHERE  NOT o1.sLevel IN(1, 2);