select handoverqty,goodqty
from (
select isnull(sum(a.handoverqty),'') handoverqty
from prog101 a join prod007 b on a.requestno=b.requestno and a.seqno=b.seqno and a.batchno = b.batchno
and a.progresscd = b.prog_cd
join prog102 e on a.requestno=e.requestno and a.seqno=e.seqno and a.batchno = e.batchno and
a.lotno=e.lotno and a.progresscd = e.progresscd
join base110 c on a.productcd=c.productcd
join base005 d on a.progresscd = d.prog_cd
where a.enddate <='2007-06-06' and (e.empgubun=1 or e.empgubun=2)and a.prognum=16
union all
select isnull(sum(a.goodqty),'') - 90 as goodqty
from prog101 a join prod007 b on a.requestno=b.requestno and a.seqno=b.seqno and a.batchno = b.batchno
and a.progresscd = b.prog_cd
join prog102 e on a.requestno=e.requestno and a.seqno=e.seqno and a.batchno = e.batchno and
a.lotno=e.lotno and a.progresscd = e.progresscd
join base110 c on a.productcd=c.productcd
join base005 d on a.progresscd = d.prog_cd
where (a.enddate ='2007-06-05' and e.empgubun=1 or e.empgubun=2 and a.prognum=17) or
(a.enddate ='2007-06-06' and e.empgubun=1 and a.prognum=17))
이놈을
handoverqty goodqty
___________________________
이렇게 값을 뿌리고 싶은데요.... 에러가 나서 검증을 못하고 있씁니다. 에러가 맨끝에 ) 부분에서 나는데요..
에러를 못잡겠네요.. 부탁드립니다.감사합니다.
|