27,579
社区成员
发帖
与我相关
我的任务
分享
select day(SPRQ) as day,sum(SJSPFKJE) as LJFK from ZJGL_GCXMZJZFSPB where IsEnd='1'
and year(SPRQ)=2010 and month(SPRQ)=7 group by day(SPRQ)
select aaa.f1,day(s.SPRQ) as day,sum(s.SJSPFKJE) as LJFK
from aaa join ZJGL_GCXMZJZFSPB s
on aaa.f1=day(s.SPRQ)
where s.IsEnd='1'
and year(s.SPRQ)=2010 and month(s.SPRQ)=7 group by day(s.SPRQ)
select aaa.f1,day(s.SPRQ) as day,sum(s.SJSPFKJE) as LJFK
from ZJGL_GCXMZJZFSPB s
join aaa
on day(s.SPRQ)=aaa.f1
where s.IsEnd='1'
and year(s.SPRQ)=2010 and month(s.SPRQ)=7 group by day(s.SPRQ)