sql - 函数时如何用例

Question

当我使用以下功能时，如何排除此代码；我可以使用'from'以防万一吗？

          SPRIDEN_ID NOT IN ((SIBINST_TERM=
             (select max(SIBINST_TERM)
                       from sibinst
                       where SIBINST_TERM<'201920'
                              and sibinst_id=spriden_id)
                 and SIBINST_FCS='AC' 
             ))

我想把它放在下面的代码中，但这会从说missiong右括号中给出错误

select  distinct 
       spriden_last,        
        case WHEN  (SPRIDEN_ID IN (SELECT SGBSTDN_ID FROM SGBSTDN) AND 
                    SPRIDEN_ID NOT IN ((SIBINST_TERM=
             (select max(SIBINST_TERM)
                       from sibinst
                       where SIBINST_TERM<'201920'
                              and sibinst_id=spriden_id)
                 and SIBINST_FCS='AC' 
             )))
                    THEN 'S'      END AS FF        
   FROM SPRIDEN,SIBINST
   WHERE spriden_id=sibinst_id     ;

标签： sql