Re: what's equiv to 'NOT IN'

[Ralph Graulich]

Hi Hawke,

>SHOW COLUMNS FROM GamerFinder WHERE Field NOT
>IN('ID','Email','PhoneNum');


You need to get through the logic of SQL, then it's easy. First make a
positive statement. Do it like this:

	[...] WHERE fieldname IN (set-definition)

As next step you negate the complete WHERE-clause, like this:

	[...] WHERE NOT (fieldname IN (set-definition))

For example:

SELECT horse,horse_country FROM dams WHERE NOT (horse_country IN("GB"))



Regards,
Ralph