Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Simple SQL question
Hi Greg,
One way is:
SELECT #USER
FROM USER_TABLE
WHERE #USER NOT IN (SELECT DISTINCT #USER FROM USER_LEVEL_TABLE);
Regards,
Rowan.
Greg gpl :-) wrote:
> 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 |
> | |
> +-------------------+
--
Remove the anti-spamming thingy from my email address to reply to me.
The opinions expressed are my own and do not represent the opinions of my company. Received on Thu May 28 1998 - 00:10:35 CDT