Jay Blanchard wrote:
[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
I can tell you the sql works fine when I alias the column
the original sql should not work at all, the column does not exist in the table, yet it returns no query error
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]