NOT IN for Multuple Values

[Evan Stockdale]

I'm trying to exclude multiple

It works when I exclude one value using NOT IN:

WHERE (((CO_CONTRACT_TYPE.SHORT_NAME)='FOB') AND ((CO_PORDER.STATUS)='O') AND ((CO_TRF_CONTAINER.WAREHOUSE_REF) Is Null) AND ((CO_TRF_CONTAINER.INVENTORIZED_DATE) Is Null) AND ((CO_TRF_CONTAINER.ARRIVAL_DATE) Is Null)) AND CO_PORDER.PO_PREFIX || '-' || CO_PORDER.PO_NUMBER || '-' || CO_PORDER.PO_SUFFIX NOT IN (SELECT CO_PORDER.PO_PREFIX || '-' || CO_PORDER.PO_NUMBER || '-' || CO_PORDER.PO_SUFFIX FROM CO_PORDER WHERE CO_PORDER.PO_PREFIX || '-' || CO_PORDER.PO_NUMBER || '-' || CO_PORDER.PO_SUFFIX = 'P-7943-A')

When I try to exclude multple values, I an error - "Missing right parenthesis"

WHERE (((CO_CONTRACT_TYPE.SHORT_NAME)='FOB') AND ((CO_PORDER.STATUS)='O') AND ((CO_TRF_CONTAINER.WAREHOUSE_REF) Is Null) AND ((CO_TRF_CONTAINER.INVENTORIZED_DATE) Is Null) AND ((CO_TRF_CONTAINER.ARRIVAL_DATE) Is Null)) AND CO_PORDER.PO_PREFIX || '-' || CO_PORDER.PO_NUMBER || '-' || CO_PORDER.PO_SUFFIX NOT IN (SELECT CO_PORDER.PO_PREFIX || '-' || CO_PORDER.PO_NUMBER || '-' || CO_PORDER.PO_SUFFIX FROM CO_PORDER WHERE CO_PORDER.PO_PREFIX || '-' || CO_PORDER.PO_NUMBER || '-' || CO_PORDER.PO_SUFFIX = 'P-7943-A,'P-7791-A')

I haven't been able to find the answer to this by looking online or in our manual. It seems my syntax is correct so I'm not sure why I'm getting this error.

Thank you