原SQL语句是这样的:
select
isnull(sum(rt.quantity),0) quantity,
isnull(sum(rt.weight),0) weight,
isnull(sum(rt.gross),0) gross,
isnull(sum(icd.mz*rt.quantity/icd.sl),0) mqs,
isnull(sum(rt.amount),0) amount,
isnull(sum(icd.je*rt.quantity/icd.sl),0) jqs
from
(select oc.* from out_ck2 oc join thd_1 t1 on oc.ckbh=t1.ckbh
where t1.is_sure='1'
) as rt
join in_ck_detail icd
on rt.goods_id=icd.goods_id
后来我要给最后一句(on rt.goods_id=icd.goods_id)加上条件,改成on (rt.is_in='0' and rt.goods_id=icd.goods_id) or (rt.is_in='1' and rt.goods_id=icd.glink)后,速度变得特别慢,请问各位还有没有别的方法?
注:以上各位所说的方法,我都试过,效果和我的写法一样