如何把空的字段填充别的~

wswfzwswfz

1. select 产品,(select 1+count(*) from (select x.产品,sum(金额) as 总金额 from [产品资料$]x left join [出库$]y on x.产品=y.产品 group by x.产品)b where b.总金额>a.总金额) as 排名,总金额 from (select x.产品,sum(金额) as 总金额 from [产品资料$]x left join [出库$]y on x.产品=y.产品 group by x.产品)a order by 3 desc

复制代码

语句如上，2表合并，求出出库金额，然后排序
具体见附件吧
谢谢各位

wswfzwswfz

您再试试，还不行您私信我给给您邮箱，完了我发您邮箱里
就是一个模拟的小表格
学习用的

hope9966

select 产品,iif(总金额 is null,null,(select 1+count(*) from (select x.产品,sum(金额) as 总金额 from [产品资料$]x right join [出库$]y on x.产品=y.产品 group by x.产品)b where b.总金额>a.总金额)) as 排名,总金额 from (select x.产品,sum(金额) as 总金额 from [产品资料$]x left join [出库$]y on x.产品=y.产品 group by x.产品)a order by 3 desc

wswfzwswfz

hope9966 发表于 2015-3-26 15:11
select 产品,iif(总金额 is null,null,(select 1+count(*) from (select x.产品,sum(金额) as 总金额 from  ...

1. select 产品,iif(总金额 is null,"无排名",(select 1+count(*) from (select x.产品,sum(金额) as 总金额 from [产品资料$]x right join [出库$]y on x.产品=y.产品 group by x.产品)b where b.总金额>a.总金额)) as 排名,总金额 from (select x.产品,sum(金额) as 总金额 from [产品资料$]x left join [出库$]y on x.产品=y.产品 group by x.产品)a order by 3 desc

复制代码

把iif里面的null改了成了无排名
搞定