| 以文本方式查看主题 - Foxtable(狐表) (http://www.foxtable.com/bbs/index.asp) -- 专家坐堂 (http://www.foxtable.com/bbs/list.asp?boardid=2) ---- [求助]视图求助！ (http://www.foxtable.com/bbs/dispbbs.asp?boardid=2&id=100442) |
| -- 作者：111yangguojun -- 发布时间：2017/5/11 14:23:00 -- [求助]视图求助！ 有 a、b、c 、d表， 视图列： SUM(A.A1) AS Z1,SUM(B.B1) AS Z2,SUM(D.D1) AS Z3 如果 Z1 = 0 ，那么 Z4 = Z3 / D 否则 Z4 = Z1 / Z2 S QL里 这个视图该如何写？
|
| -- 作者：有点色 -- 发布时间：2017/5/11 15:27:00 -- 各个表的关联是什么？具体实例发上来看看。 |
| -- 作者：111yangguojun -- 发布时间：2017/5/11 15:30:00 -- 例如 关联 都是 A.BH,B.BH,C.BH,D.BH |
| -- 作者：有点色 -- 发布时间：2017/5/11 15:41:00 --
语句1 select bh, sum(a1) as z1 from {A} group by bh 语句2 select bh, sum(b1) as z2 from {B} group by bh 语句3 select bh, sum(c1) as z3 from {C} group by bh
语句4 select bh, iif(z1=0, z3, z1/z2) as z4 from ((语句1) as a inner join (语句2) as b on a.bh = b.bh) inner join (语句3) as c on a.bh = c.bh |