17,377
社区成员
发帖
与我相关
我的任务
分享
SELECT B.BMH AS B,
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;
--用AND连接多个FILTER CONDITIONS:
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;
[Quote=引用楼主 mimi5211 的帖子:]