SELECT
s.project_property,
s.project_name,
s.project_num,
s.input_contract_num,
s.input_contract_name,
s.total_price,
s.net_interest_rate,
s.estimated_income,
s.estimated_cost,
SUM ( isnull( br.cur_back_money, 0 ) ) AS ‘monthly_actual_collection’
FROM
iwp_second_budget_approval s
LEFT JOIN iwp_back_record br ON s.input_contract_num= br.input_contract_num
GROUP BY
s.project_property,
s.project_name,
s.project_num,
s.input_contract_num,
s.input_contract_name,
s.total_price,
s.net_interest_rate,
s.estimated_income,
s.estimated_cost
左表为基础,查询右表的统计值
最新推荐文章于 2022-10-24 11:01:20 发布