Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL question
zyber wrote:
>
> 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
Hi,
select f.name, f.state from friend f
where f.name not in (select name from customer);
Erika Received on Mon Jun 08 1998 - 07:00:00 CDT