编辑代码

SELECT A.REFID C.POINTCODE,,B.TASKCODE,B.TASKTYPE
FROM LES_PP_POINT_BIND  A
LEFT JOIN LES_DT_TASK  B
ON A.ORGANIZATIONID = B.ORGANIZATIONID
AND A.WAREHOUSEID = B.WAREHOUSEID
AND A.INLDTUUID = B.LDTUUID
LEFT JOIN LES_PP_POINT C
ON A.ORGANIZATIONID=C.ORGANIZATIONID
AND A.WAREHOUSEID =C.WAREHOUSEID
AND A.LPPUUID =C.LPPUUID
WHERE B.TASKTYPE = 'ABNORMAL'