数据库查询合并，数据库是sql server 2014,求大神指点

Question

数据库查询合并，要实现的效果，见截图（实现的报表效果），颜色相同的即为关联的.
求大神指点，项目名称不能重复哟，cbs科目也不能重复。

Answer 1

这个涉及到连表操作了

 select 
a.project_name as '项目名称',
d.cbs_name as 'cbs科目',
c.act_amt as '预算',
e.remain_fc + g.je as '付款',
c.act_amt - e.remain_fc - g.je as '余额'

from 
project_table a
left join ays_cost_m b on a.pc=b.pc
left join sya_cost_d c on b.code=c.p_code
left join bd_cbs d on c.cbs=d.cbs
left join cnt_d e on d.cbs=e.cbs
left join zi_other f on e.pc=f.pc
left join zi_plan_pay g on f.code=g.code