W
wm1010
Unregistered / Unconfirmed
GUEST, unregistred user!
select IVI.CUSTNO , Sum(IVI.INVQTY * IVI.PRICE * GLE.EXRATE) CAL_AMT
from IVI left join IVM on (IVM.INVNO = IVI.INVNO)
left join INM ON IVI.MODEL = INM.PARTNO, GLE
where (GLE.CURTYPE = IVM.CURTYPE)
and (IVI.CUSTNO between '' and 'zzzzzzzz')
and (IVM.INVDATE >= '2002-06-04' and IVM.INVDATE <= '2002-06-04')
and ((INM.GRP>='' AND INM.GRP<='zzz') OR (INM.GRP IS NULL))
GROUP BY IVI.CUSTNO
Order by CAL_AMT DESC
上面是query中的sql語句,不知為什麼在Sql Server 2000中可以執行, 但在FireBird中就是
不能執行, 出現" General Sql Error column unknown CAL_AMT at line 9, column 10."錯誤.
請各位大俠幫忙, 很急呀, 我的分數隻有50分了, 全給了吧!
from IVI left join IVM on (IVM.INVNO = IVI.INVNO)
left join INM ON IVI.MODEL = INM.PARTNO, GLE
where (GLE.CURTYPE = IVM.CURTYPE)
and (IVI.CUSTNO between '' and 'zzzzzzzz')
and (IVM.INVDATE >= '2002-06-04' and IVM.INVDATE <= '2002-06-04')
and ((INM.GRP>='' AND INM.GRP<='zzz') OR (INM.GRP IS NULL))
GROUP BY IVI.CUSTNO
Order by CAL_AMT DESC
上面是query中的sql語句,不知為什麼在Sql Server 2000中可以執行, 但在FireBird中就是
不能執行, 出現" General Sql Error column unknown CAL_AMT at line 9, column 10."錯誤.
請各位大俠幫忙, 很急呀, 我的分數隻有50分了, 全給了吧!