Results 1 to 2 of 2

Thread: Select Statement

  1. #1
    Join Date
    Mar 2006
    Posts
    127

    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

  2. #2
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    You can add a where clause condition with three columns concatenated <> string you want to reject.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •