谁能帮我分析一下该语句

springhua810804

select c.cus_no,e.name, isnull(c.bzscs,0)+isnull(d.zscs,0) as zcs ,isnull(c.bzscs,0)as bzscs,
isnull(d.zscs,0) as zscs,convert(decimal(18,4),(convert(decimal(18,6),c.bzscs)/(c.bzscs+d.zscs))) as zsl
from
(select count(*) as bzscs,b.cus_no
    from (select b.qty - sum(isnull(a.qty,0)) as qty,a.os_no ,a.prd_no ,b.os_dd
           from tf_pss a,tf_pos b
           where a.os_no=b.os_no and a.prd_no=b.prd_no and a.ps_dd< b.est_dd
           group by a.os_no ,a.prd_no,b.qty ,b.os_dd
        ) a, mf_pos b
        where a.os_no=b.os_no and a.qty>0
        group by b.cus_no
) c,

(select count(*) as zscs,b.cus_no
    from (select b.qty - sum(isnull(a.qty,0)) as qty,a.os_no ,a.prd_no ,b.os_dd
           from tf_pss a,tf_pos b
           where a.os_no=b.os_no and a.prd_no=b.prd_no and a.ps_dd< b.est_dd
           group by a.os_no ,a.prd_no,b.qty ,b.os_dd
           ) a, mf_pos b
    where a.os_no=b.os_no and a.qty<=0
    group by b.cus_no
) d,cust e
where c.cus_no=d.cus_no and c.cus_no=e.cus_no
我看起来有点费劲，谁能分析一下

springhua810804

select c.cus_no,e.name, isnull(c.bzscs,0)+isnull(d.zscs,0) as zcs ,isnull(c.bzscs,0)as bzscs,
isnull(d.zscs,0) as zscs,convert(decimal(18,4),(convert(decimal(18,6),c.bzscs)/(c.bzscs+d.zscs))) as zsl
from
(select count(*) as bzscs,b.cus_no
    from (select b.qty - sum(isnull(a.qty,0)) as qty,a.os_no ,a.prd_no ,b.os_dd
           from tf_pss a,tf_pos b
           where a.os_no=b.os_no and a.prd_no=b.prd_no and a.ps_dd< b.est_dd
           group by a.os_no ,a.prd_no,b.qty ,b.os_dd
        ) a, mf_pos b
        where a.os_no=b.os_no and a.qty>0
        group by b.cus_no
) c,

(select count(*) as zscs,b.cus_no
    from (select b.qty - sum(isnull(a.qty,0)) as qty,a.os_no ,a.prd_no ,b.os_dd
           from tf_pss a,tf_pos b
           where a.os_no=b.os_no and a.prd_no=b.prd_no and a.ps_dd< b.est_dd
           group by a.os_no ,a.prd_no,b.qty ,b.os_dd
           ) a, mf_pos b
    where a.os_no=b.os_no and a.qty<=0
    group by b.cus_no
) d,cust e
where c.cus_no=d.cus_no and c.cus_no=e.cus_no

springhua810804

怎么是联在一起的啊

jefftong

回复楼主：
       请在sql查询分析器中把语举分段分条件断行就很清楚啦，关键就是a.b.c.d.e表是由嵌套查询的结果集做为关联表.附图:
      

springhua810804

问题是什么意思，起到什么效果

chamstar

看别人的还不如自已写

daiyi

密密麻麻，看起来累呀

woshisunyi

这个语句是抓对一个客户的到交货期仍未进货/销货的量以及到交货期已经超进货或销货的量

比如一个客户下了两个订单，一个要A产品100个，一个要B产品20个，如果销货是第一个按交货期销了95个，第二个按期超销了3个

则结果是 客户代号，客户名称，5+(-3)=2  zcs，5 bzscs，-3 zscs，5/2=2.5  zsl

rscpass

精！！！！！

qqqddd

{:soso_e113:}

麦麦荞

{:soso_e179:}{:soso_e179:}

syblly1982

很强悍，，看不懂！！！！