这么写

cnd.and("ID"," not in ","SELECT CONTRACTPS_TEMP_ID FROM T_PM_FBBCXYLINK");

日志这么输出给我的

AND NOT ID IN (SELECT CONTRACTPS_TEMP_ID FROM T_PM_FBBCXYLINK)

id和not位置反了
请问应该怎么写