select count(*), sum(t.realsalary)
from taxreport_temp t inner join employee e on t.id = e.id
where ( case
when e.housetax=1 then
4000
when e.housetax=0 then
1000
end)>=t.realsalary
from taxreport_temp t inner join employee e on t.id = e.id
where ( case
when e.housetax=1 then
4000
when e.housetax=0 then
1000
end)>=t.realsalary
扫一扫
5008
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
