sql报错。不知如何改啊。消息 8156，级别 16，状态 1，第 28 行

Question

select  a.scph 生产批次1,a.Pcode 产品型号3,a.Xpcode 芯片3,a.Zjcode 支架3,a.WavelengthGrade 芯片波段1,
a.produceqty,a.存量,a.Seq as 配胶方案序号1,
case a.State
when 1 then  '待首件方案'
when 2 then '待配首件'
when 3 then '待首件检验'
when 4 then  '待自主方案'
when 5 then '待配自主'
when 6 then '待自主检验'
when 7 then  '待配批量'
when 8 then '批量结束'
when 9 then '待首件方案'
end  方案状态
from
(select a.id,a.scph,b.Pcode,b.Xpcode,b.Zjcode,a.WavelengthGrade,a.Seq,a.State,c.produceqty,c.存量
     from dbo.Jit_Mucus_RateScheme a 
      inner join jit_rwd b on a.scph=b.scph  
         inner join 
         (select c.scph ,d.scph,c.produceQty,c.produceQty-d.produceQty as 存量
          from( 
                (select scph,produceqty from dbo.View_Jit_rwdProduceProcess
                 where StepName='焊芯片/芯片+zener') c
                  inner join 
                 (select scph,produceqty from dbo.View_Jit_rwdProduceProcess
                  where StepName='注胶') d
                  on c.scph  =d.scph
               )               
          ) c  on c.scph=a.Scph
     ) a     
    

Answer 1

SELECT a.scph 生产批次1,
       a.Pcode 产品型号3,
       a.Xpcode 芯片3,
       a.Zjcode 支架3,
       a.WavelengthGrade 芯片波段1,
       a.produceqty,
       a.存量,
       a.Seq AS 配胶方案序号1,
       CASE a.State
            WHEN 1 THEN '待首件方案'
            WHEN 2 THEN '待配首件'
            WHEN 3 THEN '待首件检验'
            WHEN 4 THEN '待自主方案'
            WHEN 5 THEN '待配自主'
            WHEN 6 THEN '待自主检验'
            WHEN 7 THEN '待配批量'
            WHEN 8 THEN '批量结束'
            WHEN 9 THEN '待首件方案'
       END 方案状态
FROM   (
           SELECT a.id,
                  a.scph,
                  b.Pcode,
                  b.Xpcode,
                  b.Zjcode,
                  a.WavelengthGrade,
                  a.Seq,
                  a.State,
                  c.produceqty,
                  c.存量
           FROM   dbo.Jit_Mucus_RateScheme a
                  INNER JOIN jit_rwd b
                       ON  a.scph = b.scph
                  INNER JOIN (
                           SELECT c.scph,
                                  d.scph,------是不是这里有问题，字段名相同了，加了别名试试
                                  c.produceQty,
                                  c.produceQty -d.produceQty AS 存量
                           FROM   (
                                      (
                                          SELECT scph,
                                                 produceqty
                                          FROM   dbo.View_Jit_rwdProduceProcess
                                          WHERE  StepName = '焊芯片/芯片+zener'
                                      ) c
                                      INNER JOIN 
                                      (
                                          SELECT scph,
                                                 produceqty
                                          FROM   dbo.View_Jit_rwdProduceProcess
                                          WHERE  StepName = '注胶'
                                      ) d
                                      ON c.scph = d.scph
                                  )
                       ) c
                       ON  c.scph = a.Scph
       ) a

Answer 2

-->try
select a.scph 生产批次1,a.Pcode 产品型号3,a.Xpcode 芯片3,a.Zjcode 支架3,a.WavelengthGrade 芯片波段1,
a.produceqty,a.存量,a.Seq as 配胶方案序号1,
case a.State
when 1 then '待首件方案'
when 2 then '待配首件'
when 3 then '待首件检验'
when 4 then '待自主方案'
when 5 then '待配自主'
when 6 then '待自主检验'
when 7 then '待配批量'
when 8 then '批量结束'
when 9 then '待首件方案'
end 方案状态
from
(
select a.id,a.scph,b.Pcode,b.Xpcode,b.Zjcode,a.WavelengthGrade,a.Seq,a.State,c.produceqty,c.存量
from dbo.Jit_Mucus_RateScheme a  
inner join jit_rwd b 
on a.scph=b.scph   
inner join  
(
select f.scph ,d.scph,f.produceQty,f.produceQty-d.produceQty as 存量
from
(  
(select scph,produceqty from dbo.View_Jit_rwdProduceProcess where StepName='焊芯片/芯片+zener') f
inner join  
(select scph,produceqty from dbo.View_Jit_rwdProduceProcess where StepName='注胶') d
on f.scph =d.scph
)
) c 
on c.scph=a.Scph
)a