Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: MySQL question
johnn wrote in message <3DB0E4EB.10E19ABF_at_electronmail.com>...
>Okay. I think I need to confess something. I am using MySQL. If
>someone can answer the following question given that fact, I will be
>very grateful:
>
>Let's say I have a list of usernames in the table users. Let's
>say I have a list of bad users in the table blacklist. Now, let's say I
>want to select all the usernames from the table users that are not in
>the table blacklist? How do I do this? I was thinking of stuff like
>the following:
>
>select * from users where username not in (select * from blacklist);
>
>but it doesn't work.
Mysql is under development and Version 3 does not have sub-selects. Version 4 does but has only been out a short time.
Read the outer join section of the manual at http://www.mysql.com/documentation/index.html
Have Received on Sat Oct 19 2002 - 01:54:52 CDT