尝试使用 COALESCE 分别在两个条款上：

SELECT
    ju.ID,
    ju.JENIS_USAHA,
    COALESCE(TOTAL_PEMBERI, 0) AS TOTAL_PEMBERI,
    COALESCE(OUTLET_PEMBERI, 0) AS OUTLET_PEMBERI,
    COALESCE(TOTAL_PENERIMA, 0) AS TOTAL_PENERIMA,
    COALESCE(OUTLET_PENERIMA, 0) AS OUTLET_PENERIMA,
    COALESCE(OUTLET_PEMBERI, 0) + COALESCE(OUTLET_PENERIMA, 0) AS SEMUA
FROM ...

如果这不能解决你的问题，你真的想要一个零值，当求和中的任何一项 NULL ，然后保持代码不变。