我有这条SQL语句:
SELECT ABX.ABX_APO_NUMBER,
COUNT(A1.PROCESS_MODE) AS NUM_PLANNING,
COUNT(A2.PROCESS_MODE) AS NUM_SETUP,
COUNT(A3.PROCESS_MODE) AS NUM_OUTPUT
FROM ABX, USER_INSTANCE U, ACTIVE_PROCESS A1,
ACTIVE_PROCESS A2, ACTIVE_PROCESS A3
WHERE U.ABX_APO_NUMBER (+) = ABX.ABX_APO_NUMBER
AND A1.PROCESS_INSTANCE_NUMBER (+) = U.INSTANCE_NUMBER
AND A1.PROCESS_MODE (+)= 'PLANNING'
AND A2.PROCESS_INSTANCE_NUMBER (+) = U.INSTANCE_NUMBER
AND A2.PROCESS_MODE (+) = 'SETUP'
AND A3.PROCESS_INSTANCE_NUMBER (+) = U.INSTANCE_NUMBER
AND A3.PROCESS_MODE (+) = 'OUTPUT'
GROUP BY ABX.ABX_APO_NUMBER
(+) 这个符号让PG出现了问题... 我可以直接删除它吗?如果要达到同样的效果,应该使用什么等价物Postgres才能理解呢?