SELECT CLDS.NUM_PS,CLDS.COD_ITEM,
SUM(APLD.QTY_SEND) QTY_SEND
FROM CLDS,APLY,APLD
WHERE 1 = 1 AND CLDS.NUM_PS >= 'PS08070001'and CLDS.num_ps='PS08080002'
and (SUBSTR(CLDS.NUM_PS,1,2)='PS' OR SUBSTR(CLDS.NUM_PS,1,2)='PV' )
AND SUBSTR(APLD.COD_ITEM,1,4)='0101'and CLDS.num_ps=APLY.num_ps
AND APLD.NUM_APLY=APLY.NUM_APLY and clds.dat_qcs>'20050101'
GROUP BY CLDS.NUM_PS, CLDS.COD_ITEM
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~`
select substr(pmrtd.num_mach,0,2), pmrtd.num_ps,clds.cod_item,
CLDS.QTY_PCS,CLDS.QTY_UPLOD,CLDS.QTY_PCS-CLDS.QTY_UPLOD UNUPLOD,
sum(pmrtd.hur_stnd)hur_stndt ,sum(pmrtd.hur_actu)hur_actut,
sum(pmrtd.qty_make)qty_maket, sum(pmrtd.qty_bad)qty_badt,
sum(pmrtd.qty_make)+sum(pmrtd.qty_bad)
from pmrtd,clds
where pmrtd.dat_mrtd >'20050101' and pmrtd.num_ps='PS08080002'
and (pmrtd.sts_proc='3' or pmrtd.sts_proc='0' or pmrtd.sts_proc='2')
and pmrtd.sts_mrtd='1' and clds.num_ps=pmrtd.num_ps
group by pmrtd.num_ps,substr(pmrtd.num_mach,0,2),clds.cod_item,CLDS.QTY_PCS,CLDS.QTY_UPLOD
order by pmrtd.num_ps,substr(pmrtd.num_mach,0,2) desc~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
一共有四個表,要得到其中 substr(pmrtd.num_mach,0,2), pmrtd.num_ps,clds.cod_item,
CLDS.QTY_PCS,CLDS.QTY_UPLOD, UNUPLOD等內容(有些字段省略了),
想把上述兩個查詢語句合為一句,但是要達到和這兩個查詢語句一樣的結果,實際結果就相當于
在第二個查詢語句的結果中加上一列 QTY_SEND ,數值都是一樣,但是要用一個查詢語句去實現?請問該如何做?
~~~~~~~~~~~~
小弟剛剛注冊,沒分,只能先給這么多了,謝謝大家了!
SUM(APLD.QTY_SEND) QTY_SEND
FROM CLDS,APLY,APLD
WHERE 1 = 1 AND CLDS.NUM_PS >= 'PS08070001'and CLDS.num_ps='PS08080002'
and (SUBSTR(CLDS.NUM_PS,1,2)='PS' OR SUBSTR(CLDS.NUM_PS,1,2)='PV' )
AND SUBSTR(APLD.COD_ITEM,1,4)='0101'and CLDS.num_ps=APLY.num_ps
AND APLD.NUM_APLY=APLY.NUM_APLY and clds.dat_qcs>'20050101'
GROUP BY CLDS.NUM_PS, CLDS.COD_ITEM
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~`
select substr(pmrtd.num_mach,0,2), pmrtd.num_ps,clds.cod_item,
CLDS.QTY_PCS,CLDS.QTY_UPLOD,CLDS.QTY_PCS-CLDS.QTY_UPLOD UNUPLOD,
sum(pmrtd.hur_stnd)hur_stndt ,sum(pmrtd.hur_actu)hur_actut,
sum(pmrtd.qty_make)qty_maket, sum(pmrtd.qty_bad)qty_badt,
sum(pmrtd.qty_make)+sum(pmrtd.qty_bad)
from pmrtd,clds
where pmrtd.dat_mrtd >'20050101' and pmrtd.num_ps='PS08080002'
and (pmrtd.sts_proc='3' or pmrtd.sts_proc='0' or pmrtd.sts_proc='2')
and pmrtd.sts_mrtd='1' and clds.num_ps=pmrtd.num_ps
group by pmrtd.num_ps,substr(pmrtd.num_mach,0,2),clds.cod_item,CLDS.QTY_PCS,CLDS.QTY_UPLOD
order by pmrtd.num_ps,substr(pmrtd.num_mach,0,2) desc~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
一共有四個表,要得到其中 substr(pmrtd.num_mach,0,2), pmrtd.num_ps,clds.cod_item,
CLDS.QTY_PCS,CLDS.QTY_UPLOD, UNUPLOD等內容(有些字段省略了),
想把上述兩個查詢語句合為一句,但是要達到和這兩個查詢語句一樣的結果,實際結果就相當于
在第二個查詢語句的結果中加上一列 QTY_SEND ,數值都是一樣,但是要用一個查詢語句去實現?請問該如何做?
~~~~~~~~~~~~
小弟剛剛注冊,沒分,只能先給這么多了,謝謝大家了!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货