Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> A query that uses not equals
I have a customer table
cus_code PK
cus_balance
and a invoice table
cus_code FK inv_number inv_date
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