SELECT a1.SU36,a0.*,a2.*,
IF FN02==NULL
THEN FN02
ELSIF FN02!=NULL
THEN (
IF SJ2>SJ
THEN FN04
ELSE THEN SU36
END IF
)
END IF SU36
FROM FE_APP5.Z_DFXQ a0
LEFT JOIN FE_BASE5.SYS_USERS A1 ON A0.SU00=A1.SU00
LEFT JOIN FE_APP5.Z_TG_SCORE A2 ON A0.SU00=A2.FN02
我想实现当FN02不为空时,则判断SJ2是否大于SJ,是的话则SU36的值为FN04,否则,SU36的值不变,但是这么写报from不存在,请问该怎么写合适呢