查询报错:遇到以零作除数错误。
各位大虾,帮看下是哪有错误
SELECT y.a,y.b,y.c,y.d,y.e,y.f FROM TMY y join TMZ z on
(
( cast(z.a/y.b as numeric(18,4)) + cast(z.a/y.c as numeric(18,4)) ) /
( cast(z.e/y.a as numeric(18,4)) + cast(z.e/y.b as numeric(18,4)) )
+
( cast(z.c/y.b as numeric(18,4)) + cast(z.c/y.f as numeric(18,4)) ) /
( cast(z.d/y.e as numeric(18,4)) + cast(z.d/y.f as numeric(18,4)) )
)
/
(
(cast(z.c/y.d as numeric(18,4)) + cast(z.c/y.e as numeric(18,4)) ) /
(cast(z.f/y.e as numeric(18,4)) + cast(z.f/y.f as numeric(18,4)) )
)
=0.1234
这里面没有可能是等于0的,但报错提示:遇到以零作除数错误。