declare @jf float
select @jf=jf from (select sum(jftemp) as jf from (select 出库单商品.数量*(select 积分 from 产品资料 where 产品资料.商品编号=出库单商品.商品编号) as jftemp
from 出库单商品
where 出库单商品.出库单号='CK2008050300001') i)消息 170,级别 15,状态 1,第 4 行
第 4 行: ')' 附近有语法错误。单独执行
select sum(jftemp) as jf from (select 出库单商品.数量*(select 积分 from 产品资料 where 产品资料.商品编号=出库单商品.商品编号) as jftemp
from 出库单商品
where 出库单商品.出库单号='CK2008050300001') i是正确的,会返回600
select @jf=jf
from (select sum(jftemp) as jf
from (select 出库单商品.数量*(select 积分 from 产品资料
where 产品资料.商品编号=出库单商品.商品编号) as jftemp
from 出库单商品
where 出库单商品.出库单号='CK2008050300001') i) as T