On Mon, 24 Jan 2005 10:35:22 +0100, Tom Schindl <[EMAIL PROTECTED]> wrote:
It depends on the version you are using if you have 4.1 you could use a sub-query like this:
SELECT * FROM table1 WHERE column2 NOT IN( SELECT * FROM table2.colum2 )
If using older MySQL versions like 3.23 or 4.0 you have to use left join search the web for examples and take a loom into mysql-docs which are online at dev.mysql.com.
thank you, I know this isn't an SQL support forum, but I'm grateful anyway.
-- Andrew Brown What I do: www.darwinwars.com What I'm up to: www.thewormbook.com/helmintholog/
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
