34,593
社区成员
发帖
与我相关
我的任务
分享
SELECT
b.id,
b.contractid,
b.prjname,
b.prjmanager,
b.budgetamount,
b.ownerorg,
b.jlorg,
b.settleprinciple,
b.remark,
b.createmanid,
b.createdatetime,
b.relevance,
b.createorgid,
case when b.contractid=1 then c.contractamountelse 0 end as contractamount
FROM projbudge as b
inner join contractAccount as c on c.createmanid=b.createmanid where 1=1
SELECT
b.id,
b.contractid,
b.prjname,
b.prjmanager,
b.budgetamount,
b.ownerorg,
b.jlorg,
b.settleprinciple,
b.remark,
b.createmanid,
b.createdatetime,
b.relevance,
b.createorgid,
case when b.contractid=1 then c.contractamount else 0 end as contractamount
FROM projbudge as b
inner join (SELECT createmanid, SUM(contractamount) AS contractamount --从ammount命名推测你要求和
FROM contractAccount
GROUP BY createmanid
) as c
on c.createmanid=b.createmanid
where 1=1
SELECT
b.id,
b.contractid,
b.prjname,
b.prjmanager,
b.budgetamount,
b.ownerorg,
b.jlorg,
b.settleprinciple,
b.remark,
b.createmanid,
b.createdatetime,
b.relevance,
b.createorgid,
case when b.contractid=1 then c.contractamount else 0 end as contractamount
FROM projbudge as b, contractAccount as c where 1=1
SELECT b.id, b.contractid, b.prjname, b.prjmanager, b.budgetamount, b.ownerorg, b.jlorg, b.settleprinciple, b.remark, b.createmanid, b.createdatetime, b.relevance, b.createorgid, case when b.contractid=1 then c.contractamountelse 0 end as contractamount FROM projbudge as b inner join (select distinct createmanid,contractamount from contractAccount) c on c.createmanid=b.createmanid where 1=1