1︰select NVL(sum(qty),0) as bqty
from a_sec_qc_data
where fact_no='B01P'
and sec_no='500002'
and bad_no='51010'
and rec_date>='20080823' and rec_date<='20080829'
2︰select NVL(sum(qty),0) as gqty
from a_data_5
where fact_no='B01P'
and sec_no='500002'
and rec_date>='20080823' and rec_date<='20080829'
[/code]
如何從兩張表查詢bqty,gqty ,percent(bqty/gqty)
該條語句怎麼寫啊。
我這麼寫︰select NVL(sum(a.qty),0) as bqty,
NVL(sum(b.qty),0) as gqty
from a_sec_qc_data a,a_data_5 b
where a.FACT_NO=b.FACT_NO
and a.SEC_NO=b.SEC_NO
and a.fact_no='B01P'
and a.sec_no='500002'
and b.fact_no='B01P'
and b.sec_no='500002'
and a.bad_no='51010'
and a.rec_date>='20080823' and a.rec_date<='20080829'
and b.rec_date>='20080823' and b.rec_date<='20080829'
查詢所得數據跟單條語句查詢不一致。
from a_sec_qc_data
where fact_no='B01P'
and sec_no='500002'
and bad_no='51010'
and rec_date>='20080823' and rec_date<='20080829'
2︰select NVL(sum(qty),0) as gqty
from a_data_5
where fact_no='B01P'
and sec_no='500002'
and rec_date>='20080823' and rec_date<='20080829'
[/code]
如何從兩張表查詢bqty,gqty ,percent(bqty/gqty)
該條語句怎麼寫啊。
我這麼寫︰select NVL(sum(a.qty),0) as bqty,
NVL(sum(b.qty),0) as gqty
from a_sec_qc_data a,a_data_5 b
where a.FACT_NO=b.FACT_NO
and a.SEC_NO=b.SEC_NO
and a.fact_no='B01P'
and a.sec_no='500002'
and b.fact_no='B01P'
and b.sec_no='500002'
and a.bad_no='51010'
and a.rec_date>='20080823' and a.rec_date<='20080829'
and b.rec_date>='20080823' and b.rec_date<='20080829'
查詢所得數據跟單條語句查詢不一致。
你两张表数据不一致
and a.SEC_NO=b.SEC_NO