print1.sql

地方政府非税收入管理程序。powerbulider8开发。

select p.hang,p.dwdm,d.dwname,p.sfdm,s.sfxm,sum(m.money) as yue_sum,sum(m.money) as nian_sum
from t_print1 p left join t_dwdm d on p.dwdm=d.dwdm  
		left join t_sfdm s on p.sfdm=s.sfdm  
		left join t_mx m   on p.dwdm=m.dwdm and p.sfdm=m.sfdm
group by p.hang,p.dwdm,d.dwname,p.sfdm,s.sfxm

--where p.sfdm