1金币
最佳答案WITH CTE1 AS (
Select 客户信息_id,收费金额 FROM "收费项目" where 收费类型 = "2" ),
CTE2 AS (
Select 客户信息_id,收费金额 FROM "收费项目" where 收费类型 = "1" )
Select a.日期,a.姓名,
SUM(CTE2.收费金额) as AAA,
SUM(CTE1.收费金额) as BBB
FROM "客户信息" AS a
LEFT JOIN CTE1 ON a.id = CTE2.客户信息_id
LEFT JOIN CTE2 ON a.id = CTE1.客户信息_id
GROUP BY a.id
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |