select statement question
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hi all. I hope this is the right place to ask this.
I have two tables, A and B. Each of these tables has a column with
integers. The column in table A is C and the one in B is D.
I need a select statement that will return all records whose C value is not
in any row in D.
for example:
C =
1
2
3
4
5
6
7
8
11
D =
2
4
6
8
10
and the statement would return:
1
3
5
7
11
Probably an easy question for those of you more experienced but I have no
clew.
Thanks in advance.
Sincerely
Aaron Cannon
- --
Skype: cannona
MSN/Windows Messenger: cannona@xxxxxxxxxxx (don't send email to the hotmail
address.)
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.3 (MingW32) - GPGrelay v0.959
Comment: Key available from all major key servers.
iD8DBQFFnBbLI7J99hVZuJcRAiF3AJ4mR4UjLa0sG+hIDbErj7LvuzfU4wCggEDh
DtnfmVsHL84me4qVw/mA4s8=
=l2gE
-----END PGP SIGNATURE-----
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=royale@xxxxxxxxxx