急!Access语句转换成sql2000语句!
IIf(IsNull(count-IIf(IsNull(Sum(temp.jycount)),0,Sum(temp.jycount))),0,count-IIf(IsNull(Sum(temp.jycount)),0,Sum(temp.jycount))) AS 当前可用总量,
IIf(IsNull(Sum(temp.jycount)),0,Sum(temp.jycount)) AS 当前借阅总量,
IIf(IsNull(Sum(temp2.jycount-temp2.backcount)),0,Sum(temp2.jycount-temp2.backcount)) AS 借出损失总量
-----------------------------------------------------------------------------------------------------
一个视图中的部分代码,发多了有点乱!