Select Statement

Hi All,

I have the following data that is displayed as shown:

(1) GOOD VISA CHARGE CARD
(20) GOOD WHITE PROZAC - 20 PILLS
(1) USED BROWN BELT
(1) USED BLACK KNIT HAT
(1) USED BLACK WALLET
(1) USED BLACK CELL PHONE IN CASE
(1) USED BLACK SHOE STRING
(1) USED BLUE CHAPSTICK
(1) USED MULTICOLORED MD ID
(1) USED MULTIC

This data is the result of the following select statement:

SELECT opi.property_description, rc.description, opi.quantity,
refc.description, opi.make
FROM offender_ppty_containers opc, offender_ppty_items opi,
reference_codes rc, reference_codes refc
WHERE opc.offender_book_id = opi.offender_book_id and
opc.property_container_id = opi.property_container_id and
opi.color = rc.code(+) and
opi.condition_code = refc.code(+) and
rc.domain(+) = 'PPTY_COLOR' and
refc.domain(+) = 'PPTY_CONDIT' and
opc.container_code = 'ENV' and
opc.active_flag = 'Y' and
opc.offender_book_id = 12345

I need to remove this from the results of the select statement:
(1) USED MULTIC

I have tried different things and none works. How can accomplish this?

Thanks

You can add a where clause condition with three columns concatenated <> string you want to reject.