KSQL中的语法跟SQL是不一样的
KSQL中不能把not in连着写,正确的格式应该是:not 概念别名.关系别名 in (XXXX)
参考:
String kSqlWhere ="SELECT o1.*, o1.sCode AS sPCode, o1.sName AS sPName FROM SA_OPOrg o1 WHERE o1.sCode = 'JUSTEP' AND " + "NOT o1.sLevel IN(1, 2) ";
KSQL中的语法跟SQL是不一样的
KSQL中不能把not in连着写,正确的格式应该是:not 概念别名.关系别名 in (XXXX)
参考:
String kSqlWhere ="SELECT o1.*, o1.sCode AS sPCode, o1.sName AS sPName FROM SA_OPOrg o1 WHERE o1.sCode = 'JUSTEP' AND " + "NOT o1.sLevel IN(1, 2) ";
评一波