Re: select statement question

[Chris White <chriswhite@xxxxxxxxxxxxx>]

Aaron Cannon wrote:
> -----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.

SELECT c.value FROM c WHERE c.value NOT IN (select value FROM d);

Works for me in mysql 5

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=royale@xxxxxxxxxx