Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Simple SQL question

Simple SQL question

From: Greg gpl :-) <lechkungNONOSPAM_at_tir.com>
Date: 1998/05/17
Message-ID: <355F9C22.7F2E78AB@tir.com>#1/1

This maybe incredibly stupid question but, what would be the SQL statement that would report the users that don't have an user_level entry? See the ERD below.

Thanks,
Greg
lechkung<<at>>detroitedison<<dot>>com
lechkung<<at>>tir<<dot>>com

+-------------------+

|LEVEL_TABLE        |
| #level            |
|                   |

+-------------------+
|

    /|\
+-------------------+
|USER_LEVEL_TABLE   |
| #user             |
| #level            |
|                   |

+-------------------+
\|/ |
+-------------------+
|USER_TABLE | | #user | | |
+-------------------+
Received on Sun May 17 1998 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US