select ryname,sum(isnull(gz,0)) as tgz
from
(select a.[name] as ryname,b.gz as gz
from t_ry a
left join t_gz b
on a.id=b.id
)t
group by ryname
from
(select a.[name] as ryname,b.gz as gz
from t_ry a
left join t_gz b
on a.id=b.id
)t
group by ryname
select a.[name],sum(isnull(b.gz,0)
from t_ry a
left join t_gz b
on a.id=b.id
)t
group by a.name
from t_ry a
left join t_gz b
on a.id=b.id
group by a.name
(
select a.id,a.name, sum(b.gs) as gs from t_ry a left join t_ gz b on a.id=b.id
group by a.id,a.name,)c
select a.name,sum(isnull(b.gz,0))
from t_ry a ,t_gz b
where a.Id *= b.Id
group by a.name
字段id,name
工资表t_gz
字段id,time,gzSelect a.name,b.gz
From t_ry a inner join (Select id,isnull(sum(gz),0) as gz from t_gz Group by id) b
on a.id=b.id
from t_ry M left join t_gz D on M.id=D.id
group by M.name
(select sum(gz) as gz,name from t_ry,T_gz where t_ry.id=t_gz.id group by name,gz)
group by name
select name,sum(gz) from t_ty join t_gz on t_ty.id=t_gz.id
group by name,gz
select case grouping(name)
when 0 then name
when 1 then 'all peole'
end as gongzi
,sum(gz) from t_gz join t_ty y on t_gz.id=t_ty.id
group by name,gz
with rollup
select case grouping(name)
when 0 then name
when 1 then 'all peole'
end as gongzi
,sum(gz) from t_gz join t_ty on t_gz.id=t_ty.id
group by name,gz
with rollup