SELECT DISTINCT
sp.comcode,
sp.projectname,
sp.projecttime,
sp.busnature,
sp.bustype,
sl.concode,
sl.conname,
sl.contype,
sl.conpartya,
sl.contotal,
sl.conrisedate,
sl.constopdate,
sl.contotalperiod,
(
SELECT
SUM(chargemoney)
FROM
sab_b_conpay sc
WHERE
sc.concode = sl.concode
GROUP BY
sc.concode
) AS chargemoney000,
(
SELECT
SUM(confirmamount)
FROM
sab_b_conpay sc
WHERE
sc.concode = sl.concode
GROUP BY
sc.concode
) AS confirmamount000,
(
SELECT
SUM(noconfirmamount)
FROM
sab_b_conpay sc
WHERE
sc.concode = sl.concode
GROUP BY
sc.concode
) AS noconfirmamount000
FROM
sab_b_ledger sl
LEFT JOIN sab_b_project sp ON sl.projectcode = sp.projectcode