sql語句如下:SELECT PD.order_id, PD.order_item_id, SUM(PD.amount) as amount FROM Mkt_PaymentDetail AS PD INNER JOIN Mkt_OrderItem AS OI ON PD.order_id = OI.order_id AND PD.order_item_id = OI.order_item_id WHERE PD.order_id='00008' GROUP BY PD.order_id, PD.order_item_id要求如題(當不存在00008這條記錄時,我想在sql語句中直接令SUM(PD.amount) as amount=0,不知這能否實現?),請高手賜教,謝謝!
解决方案 »
免费领取超大流量手机卡，每月29元包185G流量+100分钟通话, 中国电信官方发货