Re: MySQL and NOT INTO ...
| From: | Jayme Jeffman Filho | Date: | Mon, 17 Jul 2000 10:10:52 +0000 |
| Subject: | Re: MySQL and NOT INTO ... | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-1170@lists.php.net to get a copy of this message | ||
"SELECT * FROM A WHERE FieldID NOT IN (SELECT FieldID FROM B) ";
I hope this helps.
Jayme.
-----Mensagem original-----
De: Ingo Theiss <Theiss@medizin-forum.de>
Para: php-db@lists.php.net <php-db@lists.php.net>
Data: Segunda-feira, 17 de Julho de 2000 06:37
Assunto: [PHP-DB] MySQL and NOT INTO ...
>Hi,
>
>I got a really big problem and hope you guys can help me out :
>
>For example I´ve got two tables:
>
>Table_A: Table_B:
>1 2
>2 4
>3 7
>4 9
>5
>6
>7
>8
>9
>
>and I want to select all values From Table_A which are not in Table_B ! How
>is is it possible to do that ?
>It would be very nice if someone could give me an example.
>
>Thanx for your help !
>
>Ingo
>
>
>
>
>
>
>--
>PHP Database Mailing List (http://www.php.net/)
>To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net
>For additional commands, e-mail: php-db-help@lists.php.net
>To contact the list administrators, e-mail: php-list-admin@lists.php.net
>