SQL question

From: zyber <zybermaniac_at_hotmail.com>
Date: Thu, 04 Jun 1998 18:23:07 -0700
Message-ID: <3577487B.53BBB72@hotmail.com>

I have 2 tables:
FRIEND

---

NAME STATE

DAVE     CA
MATT     TX
HAL      VA
JAN      TX

CUSTOMER

---

NAME OWED HAL 45.50
FRANK 12.35
KEITH 5.15
JAN 12.10 How do I write SQL statement to list all friends who are not my customer?
(which is Dave and Matt)

I tried this but didn't work:

SELECT F.NAME "NAME", F.STATE "IN"
FROM FRIEND F, CUSTOMER C
WHERE F.NAME <> C.NAME;

Thanks in advance,
Z Received on Thu Jun 04 1998 - 20:23:07 CDT