程序代码：

---查询库存品种数
select COUNT(distinct ML.SPBH)as 库存品种数 from (
SELECT SPBH,SUM(SL) AS RCKC FROM (SELECT SPBH,SUM(SL) AS SL FROM RKD2
WHERE  DJLX='采购入库'  AND YSRQ<=dateadd(day,-1,CONVERT(CHAR(10),GETDATE(),120)) GROUP BY SPBH
UNION ALL SELECT SPBH,SUM(SL)*-1 AS SL FROM CKD2
WHERE  DJLX='零售出库'  AND YSRQ<=dateadd(day,-1,CONVERT(CHAR(10),GETDATE(),120)) GROUP BY SPBH) AS KCSL
GROUP BY SPBH) as kc left join SPML as ML on kc.SPBH=ML.SPBH
where MX='T'and ML.BZQ_TF in('CB','CF','YY')AND KC.RCKC<>'0'
UNION ALL
select COUNT(distinct ML.SPBH)as 库存品种数 from (
SELECT SPBH,SUM(SL) AS RCKC FROM (SELECT SPBH,SUM(SL) AS SL FROM RKD2
WHERE  DJLX='采购入库'  AND YSRQ<=dateadd(day,-1,CONVERT(CHAR(10),GETDATE(),120)) GROUP BY SPBH
UNION ALL SELECT SPBH,SUM(SL)*-1 AS SL FROM CKD2
WHERE  DJLX='零售出库'  AND YSRQ<=dateadd(day,-1,CONVERT(CHAR(10),GETDATE(),120)) GROUP BY SPBH) AS KCSL
GROUP BY SPBH) as kc left join SPML as ML on kc.SPBH=ML.SPBH
where MX='T'and ML.BZQ_TF in('CG','CX')AND KC.RCKC<>'0'
UNION ALL
select COUNT(distinct ML.SPBH)as 库存品种数 from (
SELECT SPBH,SUM(SL) AS RCKC FROM (SELECT SPBH,SUM(SL) AS SL FROM RKD2
WHERE  DJLX='采购入库'  AND YSRQ<=dateadd(day,-1,CONVERT(CHAR(10),GETDATE(),120)) GROUP BY SPBH
UNION ALL SELECT SPBH,SUM(SL)*-1 AS SL FROM CKD2
WHERE  DJLX='零售出库'  AND YSRQ<=dateadd(day,-1,CONVERT(CHAR(10),GETDATE(),120)) GROUP BY SPBH) AS KCSL
GROUP BY SPBH) as kc left join SPML as ML on kc.SPBH=ML.SPBH
where MX='T'and ML.BZQ_TF in('CT','CJ')AND KC.RCKC<>'0'
UNION ALL
select COUNT(distinct ML.SPBH)as 库存品种数 from (
SELECT SPBH,SUM(SL) AS RCKC FROM (SELECT SPBH,SUM(SL) AS SL FROM RKD2
WHERE  DJLX='采购入库'  AND YSRQ<=dateadd(day,-1,CONVERT(CHAR(10),GETDATE(),120)) GROUP BY SPBH
UNION ALL SELECT SPBH,SUM(SL)*-1 AS SL FROM CKD2
WHERE  DJLX='零售出库'  AND YSRQ<=dateadd(day,-1,CONVERT(CHAR(10),GETDATE(),120)) GROUP BY SPBH) AS KCSL
GROUP BY SPBH) as kc left join SPML as ML on kc.SPBH=ML.SPBH
where MX='T'and ML.BZQ_TF in('YP','BJ')AND KC.RCKC<>'0'
UNION ALL
select COUNT(distinct ML.SPBH)as 库存品种数 from (
SELECT SPBH,SUM(SL) AS RCKC FROM (SELECT SPBH,SUM(SL) AS SL FROM RKD2
WHERE  DJLX='采购入库'  AND YSRQ<=dateadd(day,-1,CONVERT(CHAR(10),GETDATE(),120)) GROUP BY SPBH
UNION ALL SELECT SPBH,SUM(SL)*-1 AS SL FROM CKD2
WHERE  DJLX='零售出库'  AND YSRQ<=dateadd(day,-1,CONVERT(CHAR(10),GETDATE(),120)) GROUP BY SPBH) AS KCSL
GROUP BY SPBH) as kc left join SPML as ML on kc.SPBH=ML.SPBH
where MX='T'and ML.BZQ_TF like'X%'AND KC.RCKC<>'0'

就这一条件 ML.BZQ_TF in 不一样,其他都一样,这样的语句还能精简吗 ?