34,590
社区成员
发帖
与我相关
我的任务
分享
--try
select b.yg,
sum( b.sl*b.dj-250000-
(case when datediff(day,'2011-10-9',GETDATE())<4
then 25000*datediff(day,'2011-10-9',GETDATE())
else 0 end ))as money
from hh a ,yy as b where b.yg=a.yg
and a.xx in('a0','a1','a2','a3') and a.ss not in('a','b')
group by b.yg
[Quote=引用 8 楼 geniuswjt 的回复:]select a.dj,
sum( b.sl*b.dj-250000-(case when datediff(day,'2011-10-9',GETDATE())<4 then 25000*datediff(day,'2011-10-9',GETDATE())
else 0 end ))as [money]
from hh a ,
yy as b where a.dj=b.fcpp and b.yg=a.yg and a.xx in('a0','a1','a2','a3') and a.ss not in('a','b')
group by a.dj
select
b.yg,
sum( b.sl*b.dj-250000-(case when datediff(day,'2011-10-9',GETDATE())<4 then 25000*datediff(day,'2011-10-9',GETDATE()) else 0 end ))as [money]
from
hh a ,yy as b
where
a.dj=b.fcpp and b.yg=a.yg
and
a.xx in('a0','a1','a2','a3') and a.ss not in('a','b')
group by
b.yg
select b.yg,
sum( b.sl*b.dj-250000-(case when datediff(day,'2011-10-9',GETDATE())<4 then 25000*datediff(day,'2011-10-9',GETDATE())
else 0 end ))as [money]
from hh a ,yy as b where a.dj=b.fcpp and b.yg=a.yg
and a.xx in('a0','a1','a2','a3') and a.ss not in('a','b')
group by b.yg
select b.yg,sum( b.sl*b.dj-250000-(case when datediff(day,'2011-10-9',GETDATE())<4 then 25000*datediff(day,'2011-10-9',GETDATE())
else 0 end ))as money
from hh a ,(select SUM(b.sl*b.dj) as aa,fccp,xh,yg from yy group by fccp,xh,yg) as b where a.dj=b.fcpp and b.yg=a.yg
and a.xx in('a0','a1','a2','a3') and a.ss not in('a','b')
group by b.yg