[snip] >> >> No, it isn't ignored...it just returns a FALSE for the IN statement [/snip]
More info .... "The word IN is an alias for = ANY. Thus these two statements are the same: SELECT s1 FROM t1 WHERE s1 = ANY (SELECT s1 FROM t2); SELECT s1 FROM t1 WHERE s1 IN (SELECT s1 FROM t2); However, NOT IN is not an alias for <> ANY, but for <> ALL. See Section 13.1.8.4, "Subqueries with ALL". " >From http://dev.mysql.com/doc/mysql/en/any-in-some-subqueries.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
