SQL查询,子查询作为结果字段,
SELECT code,sp.projectname,sp.projecttime,sp.busnature,sp.bustype,sl.concode,sl.conname,sl.contype,sl.conpartya,sl.contotal,sl.conrisedate,sl.constopdate,sl.contotalperiod,(SELECTSUM(chargemoney)FROMsab_b_conpay scWHEREsc.concode = sl.concodeGROUP BYsc.concode) AS chargemoney000,(SELECTSUM(confirmamount)FROMsab_b_conpay scWHEREsc.concode = sl.concodeGROUP BYsc.concode) AS confirmamount000,(SELECTSUM(noconfirmamount)FROMsab_b_conpay scWHEREsc.concode = sl.concodeGROUP BYsc.concode) AS noconfirmamount000FROMsab_b_ledger slLEFT JOIN sab_b_project sp ON sl.projectcode = sp.projectcode