如下图所示,我想要实现当登录人员角色为5时,可以不需要这个条件,当不是5时,就要写lrry=登录人员这个条件但是我写casewhen怎么显示报错呢该如何写呢SELECT a.ywbzh, a.ywbzhlx,a.fplx, a.yxlx, a.khjlh, b.zgxm, a.ed, a.qz, a.sxksrq, a.lrrq , a.pch, a.xh,c.mcFROM ylalrb a LEFT JOIN ryb b ON a.khjlh=b.rybh left join ymhjbdmb c on a.ywbzhlx=c.dm where a.fhbz='0' (case when '${fin_role}'=5 then '' else and lrry='${finename}' end)