请问版主这个写法改怎么写。。

[mzwhq]

case when {#源表#.freasoncode}<>'913' then select _x_fcz t_INVD_StkInLogItem where fStkInLogNo={#源表#.fstkinlogno} and fGoodsID={#源表#._x_f006} and fSNo={#源表#.fsno}
else select _x_fxc t_INVD_StkOutLogItem where fstkoutlogno={#源表#.fstkinlogno} and fGoodsID={#源表#._x_f006} and fSNo={#源表#.fsno} end

[吉普赛的歌]

不知道你这是弄的啥， 伪码？配置文件？

瞎猜， 看能不能蒙对。

SELECT _x_fcz 
FROM t_INVD_StkInLogItem AS a INNER JOIN #源表# AS b
	ON		a.fStkInLogNo =  b.fstkinlogno
       AND	a.fGoodsID    = b._x_f006
       AND	a.fSNo        = b.fsno
WHERE b.freasoncode} <> '913'
UNION ALL
SELECT _x_fcz 
FROM t_INVD_StkOutLogItem AS a INNER JOIN #源表# AS b
	ON		a.fstkoutlogno =  b.fstkinlogno
       AND	a.fGoodsID    = b._x_f006
       AND	a.fSNo        = b.fsno
WHERE b.freasoncode = '913'