select b.bmh as b,a.pycj as d41,b.pycj as d42,c.pycj as d43,a.pycj+b.pycj+c.pycj as zcj from t_1_a_41_pyjd a,t_1_a_42_pyjd b,t_1_a_43_pyjd c where a.bmh=b.bmh,b.bmh=c.bmh;
其中:
t_1_a_41_pyjd,t_1_a_42_pyjd,t_1_a_43_pyjd是三个表。我想把三个pycj加在一起啊。
其中:
t_1_a_41_pyjd,t_1_a_42_pyjd,t_1_a_43_pyjd是三个表。我想把三个pycj加在一起啊。
这样两个加,没有问题啊,为什么加第三个就错了
SELECT B.BMH AS B,
A.PYCJ AS D41,
B.PYCJ AS D42,
C.PYCJ AS D43,
A.PYCJ + B.PYCJ + C.PYCJ AS ZCJ
FROM T_1_A_41_PYJD A, T_1_A_42_PYJD B, T_1_A_43_PYJD C
WHERE A.BMH = B.BMH
AND B.BMH = C.BMH;
A.PYCJ AS D41,
B.PYCJ AS D42,
C.PYCJ AS D43,
nvl(A.PYCJ,0) + nvl(B.PYCJ,0) + nvl(C.PYCJ,0) AS ZCJ
FROM T_1_A_41_PYJD A, T_1_A_42_PYJD B, T_1_A_43_PYJD C
WHERE A.BMH = B.BMH
AND B.BMH = C.BMH;
where a.bmh=b.bmh,b.bmh=c.bmh;
to
where a.bmh=b.bmh and b.bmh=c.bmh;