Acess查询的错误

 command.SQL = "SELECT SID FROM TB_WFACTIVITYINSTANCE WHERE STATUS = :TB_WFACTIVITYINSTANCE_STATUS0 AND ROCINSTANCE_SID IN ( SELECT SID FROM TB_WFPROCESSINSTANCE WHERE  PROCNAME = :TB_WFPROCESSINSTANCE_PROCNAME0 )";

不能够查询出结果

command.SQL = "SELECT SID FROM TB_WFACTIVITYINSTANCE WHERE ( PROCINSTANCE_SID IN ( SELECT SID FROM TB_WFPROCESSINSTANCE WHERE  PROCNAME = :TB_WFPROCESSINSTANCE_PROCNAME0 ) ) AND ( STATUS = :TB_WFACTIVITYINSTANCE_STATUS0 )";


能够查询出结果

明显就是Access的BUG