Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> A query that uses not equals

A query that uses not equals

From: Cherron <twitched_at_msn.com>
Date: 27 Oct 2002 10:36:54 -0800
Message-ID: <bd72678d.0210271036.41af0fe2@posting.google.com>


I have a customer table

cus_code PK
cus_balance

and a invoice table

cus_code  FK
inv_number
inv_date

invo_items

I need to be able to select the customers that did not make purchases on 8/18/1999 and 8/19/1999

The code that I came up which is listed below does not work because the syntax is wrong and I gues the logic as well.

SELECT CUSTOMER.CUS_CODE, CUSTOMER.CUS_BALANCE FROM CUSTOMER, INVOICE
WHERE INVOICE.INV_DATE != "08/18/1999" OR INVOICE.INV_DATE != " 08/19/1999"
ORDER BY CUSTOMER.CUS_CODE; Can anyone tell me what I am doing wrong? I would appreciate your help.

Thanks Received on Sun Oct 27 2002 - 12:36:54 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US