Re: Simple SQL question

Or use an outer join and a null in the where clause:

select * from user_table u, user_level l where u.user = l.user (+)
and l.user is null;

--
Matt Brennan
SQL*Tools Specialist
GERS Retail Systems
9725-C Scranton Road
San Diego, California 92121
1-800-854-2263
mbrennan_at_gers.com
(Original email address is spam-blocked.)

Carsten Busch <ncb_at_geogr.uni-jena.de> wrote in article <355FFCA0.5D61_at_geogr.uni-jena.de>...
> try a solution with a subquery:
>
> SELECT * FROM user_table WHERE user NOT IN
> (SELECT user FROM user_level_table)

[snippage] Received on Mon May 18 1998 - 11:33:48 CDT