RE: [PHP-DB] MySQL and NOT INTO ...
| From: | Zylski Marcin | Date: | Mon, 17 Jul 2000 09:46:41 +0000 |
| Subject: | RE: [PHP-DB] MySQL and NOT INTO ... | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-1169@lists.php.net to get a copy of this message | ||
HI!!
Try something like this:
SELECT *
FROM Table_A
WHERE Number_Column NOT IN
(SELECT Number_Colum FROM Table_B);
I don't know the name of column with your numbers, so I called it by my
self, but it's important to use right name because SQL needs to know which
columm use as selector.
--
-- Marcin Żylski, dział IT
-- email: marcin.zylski@upc.com.pl
-- tel. +48 32 20 07 485
--
-----Original Message-----
From: Ingo Theiss [mailto:Theiss@medizin-forum.de]
Sent: Monday, July 17, 2000 11:38 AM
To: php-db@lists.php.net
Subject: [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
---------------------------------------------------------
This message has been scanned for viruses by MIMESweeper.
Wiadomosc zostala sprawdzona pod katem wirusow przez
oprogramowanie MIMESweeper.
---------------------------------------------------------
This message has been scanned for viruses by MIMESweeper.
Wiadomosc zostala sprawdzona pod katem wirusow przez
oprogramowanie MIMESweeper.