Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> RE: Simple SQL Question
On May 17 Greg gpl asked:
...what would be the SQL statement that would report the users that don't have an user_level entry?...
An even simpler form of the answer (and much faster if you've got big tables) is:
select user from user_table
minus
select user from user_level_table;
Received on Fri May 22 1998 - 13:59:45 CDT