34,576
社区成员
发帖
与我相关
我的任务
分享
SELECT EQU_POLE.BASICINFOID,EQU_POLE.SPAN, EQU_BASICINFO.ID, LINE.LINELENGTH
FROM LINE RIGHT OUTER JOIN
EQU_BASICINFO
ON LINE.ID = EQU_BASICINFO.ID RIGHT OUTER JOIN
( SELECT basicinfoid, SUM(span) "span"
FROM EQU_POLE
GROUP BY basicinfoid) EQU_POLE ON EQU_BASICINFO.ID = EQU_POLE.BASICINFOID
where EQU_POLE.SPAN <> LINE.LINELENGTH