SELECT "SP_OTHER_CHECK_SUB"."ITEM_CODE"
FROM "SP_OTHER_CHECK_SUB" FULL OUTER JOIN
"SP_OTHER_RECEIVE_SUB"
on ("SP_OTHER_CHECK_SUB"."ITEM_CODE" =
"SP_OTHER_RECEIVE_SUB"."ITEM_CODE") and
("SP_OTHER_RECEIVE_SUB"."ITEM_CODE" = 'PTMAF0332'
FROM "SP_OTHER_CHECK_SUB" FULL OUTER JOIN
"SP_OTHER_RECEIVE_SUB"
on ("SP_OTHER_CHECK_SUB"."ITEM_CODE" =
"SP_OTHER_RECEIVE_SUB"."ITEM_CODE") and
("SP_OTHER_RECEIVE_SUB"."ITEM_CODE" = 'PTMAF0332'
我试了你的方法可是提示命令未正确结束
FROM "SP_OTHER_CHECK_SUB",
"SP_OTHER_RECEIVE_SUB"
WHERE ("SP_OTHER_CHECK_SUB"."ITEM_CODE"(+) =
"SP_OTHER_RECEIVE_SUB"."ITEM_CODE") and
("SP_OTHER_RECEIVE_SUB"."ITEM_CODE" = 'PTMAF0332')