我猜你所說的"某項為空"指的是為null吧??如果是,則可以用ISNULL來搞掟,否則請用CASESELECT INVH.customer AS customer, INVH.cause_code AS cause_code, INVH.stock_bill AS bill, INVH.trans_date AS clientage_date, INVH.bill_type AS bill_type, ( SELECT ISNULL(SUM(amt),0) FROM inv_trans_detail INVD WHERE INVD.bill=INVH.stock_bill AND (INVH.bill_type='1111' OR INVH.bill_type='3333')) AS debtor , ( SELECT ISNULL(SUM(amt),0) FROM inv_trans_detail INVD WHERE INVD.bill=INVH.stock_bill AND (INVH.bill_type='4444' OR INVH.bill_type='3333')) AS lender , INVH.checkman AS checked FROM inv_trans_detail_head INVH
哦 忘了说了 是Oracle阿 妹妹好 多谢你啊 不过 我的这个语句怎么改呢?
IN ORACLE YOU MAY USE THIS STATEMENT SELECT NVL(LENDER, 0) FROM DUAL;
INVH.cause_code AS cause_code,
INVH.stock_bill AS bill,
INVH.trans_date AS clientage_date,
INVH.bill_type AS bill_type,
( SELECT ISNULL(SUM(amt),0)
FROM inv_trans_detail INVD
WHERE INVD.bill=INVH.stock_bill AND (INVH.bill_type='1111' OR INVH.bill_type='3333')) AS debtor ,
( SELECT ISNULL(SUM(amt),0)
FROM inv_trans_detail INVD
WHERE INVD.bill=INVH.stock_bill AND (INVH.bill_type='4444' OR INVH.bill_type='3333')) AS lender ,
INVH.checkman AS checked
FROM inv_trans_detail_head INVH
妹妹好 多谢你啊 不过 我的这个语句怎么改呢?
YOU MAY USE THIS STATEMENT
SELECT NVL(LENDER, 0) FROM DUAL;