SELECT SUM(NVL(inspect_total1, 0)),SUM(NVL(owner_total1, 0)),SUM(NVL(report_total1, 0))
FROM CONTRACT_REPORT_QTY_LINE_TAB
WHERE contract_no = 'MWⅡ/C1'
AND contract = 'MWⅡ'
AND report_no = '9'
AND (item_no ='1'
or item_no LIKE '1'||'.'||'%')
FROM CONTRACT_REPORT_QTY_LINE_TAB
WHERE contract_no = 'MWⅡ/C1'
AND contract = 'MWⅡ'
AND report_no = '9'
AND (item_no ='1'
or item_no LIKE '1'||'.'||'%')
就要看你自己设定的条件了。